Re: Oracle Web proc. to query mult. db's

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/10/11
Message-ID: <343ed8f8.31875124@newshost>#1/1

On Fri, 10 Oct 1997 18:46:50 GMT, Oracle_man <rheadrick_at_shl.com> wrote:

>Greetings,
>
>I need a pl/sql procedure that I can use with oracle web server 2.1 on
>NT to query all db's listed in my tnsnames.ora.
>
>All responses appreciated,
>
>Rich

Well, you can't query all of the databases in your tnsnames.ora file but... you can easily query any database you have created a database link for. Once you are connected to the database and running pl/sql -- you are connected to the database. pl/sql can't log out and log back in (it is running in the server after all). If you create database links to other databases you can query whatever you need via the database link (dynamically even using dbms_sql if you want).

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Oct 11 1997 - 00:00:00 CDT