Re: connecting to two different instances from a ORA PL/SQL procedure

"Jon" <aaa_at_bbb.ccc> a écrit dans le message news: bqf3un$31a$1_at_unbe.sarenet.es...
> From a PL/SQL block, I need to connect to two different ORA instances in
> order
> to compare data contained in two tables, one in each of the instances ...
> ¿is
> is possible?
>
>

Hello,
At first glance if you need to connect to some different instances, perhaps you should consider using DBlinks.
If your goal is to compare two tables, send the output of a select * from my_table order by my_key to a file
for each table and, then, use a compare utility (like UNIX diff). It's a little bit DIY but it works as a one-shot solution.

Cheers,
Alkos Received on Mon Dec 01 2003 - 04:36:32 CST