Re: Accessing non-oracle DB from PL-SQL

How do you create database links ? I dont think it is possible to connect through ODBC DSN in SQL Plus.

Piyush.

Stephan Born wrote in message <38C8B849.6241A804_at_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 - 14:21:00 CST