Home » SQL & PL/SQL » SQL & PL/SQL » is this possible
is this possible [message #37457] Fri, 08 February 2002 08:27 Go to next message
Suresh
Messages: 189
Registered: December 1998
Senior Member
Hi,

I have to execute two stored procedures.
first1 from local server and second one from remote server.
and i have to join both the outputs into one.
is this possible, If yes How?
If i use 2 cursors in each stored procesures how to join two cursors.
appreciate your help
suresh
Re: is this possible [message #37459 is a reply to message #37457] Fri, 08 February 2002 09:48 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
This is one way. If the remote server is accessible connect to local server with SQLPlus:

sqlplus user/password
SQL> spool FILENAME
SQL> exec proc_local
SQL> connect user/password@remote
SQL> exec proc_remote
SQL> spool off

Make sure you have an alias in your tnsnames.ora file. Note that the password will be in the spooled file.

Not sure what you mean by joining cursors. You need to be more specific on what you are trying to do.
Re: is this possible [message #37480 is a reply to message #37459] Mon, 11 February 2002 10:26 Go to previous message
ron
Messages: 50
Registered: July 1999
Member
are you trying to concatenate 2 columns values ?

can you post how the output looks from 2 proc.

is that a row or 1 column.

so that I can post appropriate sol.
Previous Topic: help
Next Topic: PARTITION PROBLEM
Goto Forum:
  


Current Time: Thu Mar 28 08:04:42 CDT 2024