How to call dynamic remote stored procedure in the dynamic sql

Hi,

My local procedure needs to call a remote stored procedure which dblink name is built at the run time depending on the input parameter to the local procedure. Therefore depending on the input parameter, the remote procedure may reside at different remote databases. Try to avoid hardcode value in "if/elsif". Thinking to use dbms_sql and pass the dynamically built remote procedure to it but somehow it doesn't work. Any idea?

thanks,
Charley Received on Fri Aug 22 2003 - 22:05:42 CEST