Accessing non-oracle DB from PL-SQL

From: MPG <pg_miguel_at_hotmail.com>
Date: Wed, 08 Mar 2000 13:09:37 GMT
Message-ID: <lisx4.12969$ys3.79145@telenews.teleline.es>

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 Received on Wed Mar 08 2000 - 07:09:37 CST