is this possible [message #37457] |
Fri, 08 February 2002 08:27 |
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 |
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 |
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.
|
|
|