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

It is not the synonym that allows to call remote objects. It is database link. You create a link to remote database and issue:

remote_procedure_at_dblink;

Yes, you can create a synonym remote_procedure for remote_procedure_at_dblink for less typing but it is just matter of convenience.

Solomon Yakobson.

In article <6p921d$fsv$1_at_nnrp1.dejanews.com>,   basilodbc_at_my-dejanews.com wrote:
> In article <35B4E1F0.A5F5C65A_at_digitalriver.com>,
> Steve Livingston <slivings_at_digitalriver.com> wrote:
> > How can a PLSQL procedure call a PLSQL procedure on another machine?
> >
> > Cheers,
> > Steve
> >
> >
> Sure can....
> you can even create a synonym for it, unless you procedure is in a
> package. Last time I tried to create a synonym for a packaged procedure
> it failed.
>
> CREATE SYNONYM remote_proc FOR someuser.proc;
>
> In the local stored procedure.
>
> BEGIN
>
> EXEC remote_proc(myvar1,myvar2,...)
>
> END;
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Jul 25 1998 - 09:52:22 CDT