Re: How to avoid writing a distributed query in PL/SQL?

From: Kaboel Karso <kaboel_at_wau.mis.ah.nl>
Date: 1997/12/17
Message-ID: <34a0f212.25632727@waubel.wau.mis.ah.nl>#1/1

How about a snapshot?

On Tue, 16 Dec 1997 15:39:03 -0500, Nagesh Chigurupati <abcd_at_efgh.com> wrote:

>Hi everyone,
>
> I am in a situation where I have to write a query in a procedure that
>is join between tables on two
> servers. I basically have to retrieve data on a remote server based on
>
>values of a column in the
> local database.
>
> Eg:
> Column_values_on_local = '1','2','3','4',.......
>
> Now is there a way to store these in a local variable such as a table
>or record and then use these
> variables in the query for the remote table? This way I could avoid
>writing a distributed join query.
>
>Any response would be greatly appreciated.
>
>Thank you.
>
>Nagesh

Kaboel Karso Received on Wed Dec 17 1997 - 00:00:00 CST