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 clod
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 setup_replication_group_lo
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 Weatherma
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 ###
...
...
dbms_offlin
