Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it possible to calling another stored procedure in another database?

SniipeJul 27 2007 — edited Jul 31 2007
Hello all, I hope you can help me out.

I need to call another stored procedure in another database? Is it possible?
I know you can call another stored procedure in the same package:

Var_SQL :='call SP_Tes (''' || Var_1 || ''',''' || Var_2 ||''')' ;
EXECUTE IMMEDIATE Var_SQL;

But how do call it if its in another database? I assume, I'd have to open a new connection to it, then call it...

Please help me. thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2007
Added on Jul 27 2007
28 comments
4,307 views