Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to avoid distributed query in PL/SQL???
Nagesh,
The thing to do would be to write a stored procedure, install it on the remote machine, then execute it from the local machine passing the column_value_on_local as a parameter.
my_proc_at_remote_link(col_val);
Regards
--Received on Wed Dec 17 1997 - 00:00:00 CST
*************************
Gary Smith CERN, Geneva, Switzerland Email: Gary.Smith_at_cern.ch Tel: +41 22 7678944
*************************