accessing multiple instances
From: naimy <naimy4_at_yahoo.com>
Date: 18 Jul 2004 12:48:14 -0700
Message-ID: <d028e345.0407181148.89f12d0_at_posting.google.com>
Hi,
I need to access more that 1 instance, is there a way to start a new connection from a pl/sql script ?
eg.
inst1 has table I1
inst2 has table I2
Date: 18 Jul 2004 12:48:14 -0700
Message-ID: <d028e345.0407181148.89f12d0_at_posting.google.com>
Hi,
I need to access more that 1 instance, is there a way to start a new connection from a pl/sql script ?
eg.
inst1 has table I1
inst2 has table I2
I need to query I2 using columns from I1. It may sound unusual etc.etc.
I have stored the field-values its just one column from I1 and want to
connect to I2.
I thought that the following would work, but it didnt
declare
begin
execute immediate 'conn abc/abc_at_inst2 ';
end;
/
Want to run something like this
declare
curosr c is
select 1,2,3,4 from inst1.table1 where ---- ;
c_rec is c%rowtype;
begin
for c_rec in c loop
select c1 into holder1 from inst2.table2 where (.....);
end loop;
end;
/
Thanks,
Naimy
Received on Sun Jul 18 2004 - 21:48:14 CEST