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
