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

From: <basilodbc_at_my-dejanews.com>
Date: Fri, 24 Jul 1998 04:19:57 GMT
Message-ID: <6p921d$fsv$1@nnrp1.dejanews.com>

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 Received on Thu Jul 23 1998 - 23:19:57 CDT