Hi, everyone
I am software developer. This week I started to work for a company that uses Win2000 as ther domain server. My asked me to install Symantec Web Security. After installation I was requested to restart the server. I did, but after I logged in, the sorprise: the Windows desktop is...
Hello, Dima
The error I receive is this
Server: Msg 7212, Level 17, State 1, Line 2
Could not execute procedure 'HELLO' on remote server 'oracle'.
[OLE/DB provider returned message: One or more errors occurred during processing of command.]
I have tried everything. I've jumped to the...
Hello everyone!
Currently I am developing a distribuited application for a local bank in my country. In this moment I am developing the business layer using stored procedures in SQL Server 2000, but I have to use data from different data sources, including Oracle and other SQL Servers. I have...
Did you actually tested that code?
I wrote this version of your post:
declare @data varchar(60)
execute oracle..EDALORZO.HELLO 1
set @data = (Select friendcode from oracle..dual)
And this is the output
Error: Could not execute procedure 'HELLO' on remote server 'oracle'.
More exceptions...
It works in Oracle:
DECLARE
FRIENDCODE NUMBER := 1;
FRIENDNAME VARCHAR2(25) := '-';
BEGIN
EDALORZO.HELLO(FRIENDCODE, FRIENDNAME);
DBMS_OUTPUT.PUT('FRIENDCODE: ');
DBMS_OUTPUT.PUT_LINE(FRIENDCODE);
DBMS_OUTPUT.PUT('FRIENDNAME: ');
DBMS_OUTPUT.PUT_LINE(FRIENDNAME);
END;
Produces this...
Thanks for your reply Dbomrrsm. Nevertheless the code that you posted produces this error:
Error: Incorrect syntax near the keyword 'execute'.
I guess you meant:
declare @data varchar(60)
execute @data = oracle..EDALORZO.HELLO 1
print @data
However this code produces this error:
Server...
Hello everyone!
Currently I am developing a distribuited application for a local bank in my country. In this moment I am developing the business layer using stored procedures in SQL Server 2000, but I have to use data from different data sources, including Oracle and other SQL Servers. I have...
In our company we develope using C++ Builder. Some questioning about if we should consider moving to Microsoft Visual C++ or even .Net C++ or .Net C# have arised in these days.
The problem is that we do not want to rewrite all the code that is already written in C++ Builder.
Does anyone of you...
Well you can combine different kind of readers and writes to do different things. Heres a runnable example of the different things you might want to do.
package tektips;
import java.io.*;
import java.util.List;
import java.util.ArrayList;
public class Readers {
public static void...
I recommend you to visit this link:
http://java.sun.com/developer/onlineTraining/Servlets/Fundamentals/contents.html
It will introduce you on the subject.
edalorzo@hotmail.com
Maybe you should try a Java Beans Approach. When data changes in class B you have to notify to one or more objects who registered their listeners with class B object.
Please give it a look at this sample code I took from Robert Englader Book: Developing Java Beans
You can copy it and run it. I...
I think the decision depends on the application you're building and the organization you work for.
If your are building a small business database you could use free database like MySQL or PostgreSQL (Linux).
If your application is mission critical you might consider SQL Server (for a Windows...
There are serveral ways to do that. But first, you have to notice that in your code Class A and Class B are not related at all.
In this case, I mean, if your classes are not related, you may want to use composition instead of inheritance. That's to say, you can create a wrapper (or Adpater)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.