Home » SQL & PL/SQL » SQL & PL/SQL » How to make connections to different dbs from PL/SQL
How to make connections to different dbs from PL/SQL [message #19069] Wed, 27 February 2002 07:07 Go to next message
Murali Sai M
Messages: 4
Registered: February 2002
Junior Member
Hi all
Can anyone tell me how to get connected from PL/SQL to different databases using connect statement?
Urgent

Murali Sai
Re: How to make connections to different dbs from PL/SQL [message #19075 is a reply to message #19069] Wed, 27 February 2002 09:14 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi

You cannot connect to remote db from plsql procedure.
Either you should use
dynamic sql (execute immediate) to run a
sql statement at the remote db..

EX:
begin
execute immediate 'insert into emp@remotedb1 values (...)';
end;

or you have to do Remote Procedure calls.
You can execute the remote procedure with in the
local procedure.
Previous Topic: SEARCHING BETWEEN TWO DATES
Next Topic: report runs slowly
Goto Forum:
  


Current Time: Thu Mar 28 06:38:07 CDT 2024