Home » SQL & PL/SQL » SQL & PL/SQL » procedures connecting to non Oracle databases
procedures connecting to non Oracle databases [message #38444] Wed, 17 April 2002 22:02 Go to next message
NJManan
Messages: 1
Registered: April 2002
Junior Member
is it possible to create an Oracle database procedure that will connect to and extract data from a non Oracle database? how?

Report message to a moderator

Re: procedures connecting to non Oracle databases [message #38481 is a reply to message #38444] Sun, 21 April 2002 21:35 Go to previous message
Dinesh
Messages: 31
Registered: October 2001
Member
Hi,

Before using in sp make database link to non oracle system.first chk it by select statement using dblink.
then u can use it in sp

bye

Report message to a moderator

Previous Topic: URGENT!!! How to resolve ORA-04020 Exception
Next Topic: INSERT MULTIPLE DATA USING A SINGLE STATEMENT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 09:16:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.