Re: PLSQL-proc calling PLSQL-proc on another machine

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 21 Jul 1998 20:40:56 GMT
Message-ID: <35bffca3.28543843@192.86.155.100>

A copy of this was sent to Steve Livingston <slivings_at_digitalriver.com> (if that email address didn't require changing) On Tue, 21 Jul 1998 13:46:09 -0500, you wrote:

>How can a PLSQL procedure call a PLSQL procedure on another machine?
>
>Cheers,
>Steve

create a database link, for example create one called 'foo', that links to the other machine.

Test the link with "select * from dual_at_foo" in sqlplus to make sure it works.

Then you can

begin
  some_procedure_at_foo( inputs... );
end;  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Jul 21 1998 - 15:40:56 CDT