I am in the process of writing a pl/sql block to run on instance A. At one
point, I need to run a procedure that resides in instance B against instance
B's dataset. Is there an easy way to do this?
The basic problem is:
### Set up Instance Source for replication ###
...
...
Create a dblink to instance B from A and then within your
proc on A do
proc_on_b@B_INSTANCE(parameter1parameter_n);
The schema that you use for the link to B must have execute
access to the procedure on B
HTH
Jeff Herrick
Jeff HErrick Associates
On Tue, 25 Jun 2002, John
Jeff,
Thanks, this looks really close. One refinement though, I need to pass the
target link name as a parameter. The name is already being passed, I just
need the link syntax to interprit the variable before trying to use it. Any
advice?
create or replace procedure
you will have to use dynamic sql to do what you want to do.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any
