Linked Servers

From: Phoenix <news_at_rons-world.net>
Date: Sun, 14 Sep 2003 13:56:08 -0700
Message-ID: <3F64D5E8.3246E7C1_at_rons-world.net>

Greetings all,
I am collecting data from 16 different Oracle databases into a single database. I have a stored procedure to do this, but I'd like to pass the procedure a value (linked Oracle database name) and have the stored procedure do something similar to:

select * from table_at_v_remoteserver

where v_remoteserver is a variable.

Thanks all,

Ron Hagerman
http://www.rons-sandbox.com Received on Sun Sep 14 2003 - 22:56:08 CEST

This message: [ Message body ]
Next message: ceteris: "Oracle Real Aplication Cluster"
Previous message: Gary: "Re: She doesn't want the ODBC users to see system views/tables via M$ Access."
Next in thread: Billy Verreynne: "Re: Linked Servers"
Reply: Billy Verreynne: "Re: Linked Servers"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message