Skip to Main Content

APEX

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!

Calling a procedure through a database link

DaggersAug 12 2009 — edited Aug 13 2009
I want to be able to execute procedures on remote databases. I do this after some lov's and text feilds have been entered and the submit button is clicked(this is a page process running PL/SQL anonymous block). Problem is the name of the procedure is dependant on the name of the database selected. For example this works:

dba_audit_pkg.create_user@remoteDB(
pi_username => :USERID
,pi_type => 'SUPPORT'
,pi_dbname => 'IB');

but this does not:

dba_audit_pkg.create_user@:P1_DATABASE(
pi_username => :USERID
,pi_type => 'SUPPORT'
,pi_dbname => 'IB');

Does anyone know how I can generate the name of a procedure depending on a variable ?

Thanks
Steve
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2009
Added on Aug 12 2009
2 comments
628 views