Forum Stats

  • 3,817,367 Users
  • 2,259,322 Discussions
  • 7,893,760 Comments

Discussions

Calling a procedure through a database link

Daggers
Daggers Member Posts: 47
edited Aug 13, 2009 6:54PM in APEX Discussions
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:

[email protected](
pi_username => :USERID
,pi_type => 'SUPPORT'
,pi_dbname => 'IB');

but this does not:

[email protected]: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

Answers

This discussion has been closed.