Re: Accessing non-oracle DB from PL-SQL

From: Stephan Born <stephan.born_at_beusen.de>
Date: Fri, 10 Mar 2000 09:54:33 +0100
Message-ID: <38C8B849.6241A804@beusen.de>

> Hi folks,
>
> I am trying to access from a stored procedure in a local oracle db(oracle 8i
> for NT) a non-oracle remote database (SQL-server db).
> Until now, what I've been able to do is accessing the remote db from
> sql-plus by creating an ODBC origin for SQL-server with the Microsoft ODBC
> Administrator, and using that ODBC origin as the Host string in the sql-plus
> connection. This works OK, but what I need is to be able to access the
> remote non-oracle db from PL/SQL. Can anybody give me a hint on how to do
> this?
>
> Cheers

It is possible to connect from sqlplus to a database using ODBC? Wow....

Did you try database links? With this you can access objects on a remote-db from within a procedure, at least remote oracle-dbs.

Regards, Stephan Received on Fri Mar 10 2000 - 02:54:33 CST