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

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 Received on Tue Dec 16 1997 - 00:00:00 CST