Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Running procedures remotely

Re: Running procedures remotely

From: <harronc_at_ibm.net>
Date: Tue, 31 Aug 1999 10:45:28 +0700
Message-ID: <37CB4FD7.52E48646@ibm.net>

Looks good but I would recomend using a synonym to hide the database link otherwise you end up with the database link name in the ProC executable which will be a bit rigid.

Ciaran

Kenneth C Stahl wrote:

>
>
> So if I need to pass parameters would I do something like:
>
> exec remote_proc(var1,var2,var3,etc)@db_link;
>
> What if I just needed to call the remote procedure from within a locally
> executing script? Would it be:
>
> declare
> var1 varchar2;
> var2 number(3);
> var3 date;
> begin
> remote_proc(var1,var2,var3,etc)@db_link;
> end;
>
> And then again, what if I were calling the remote procedure from Pro-C? Would it
> be
>
> EXEC SQL EXECUTE
> DECLARE
> var1 varchar2;
> var2 number(3);
> var3 date;
> BEGIN
> remote_proc(var1,var2,var3,etc)@db_link;
> END;
> END-EXEC;
>
> Does all of this look reasonable?
Received on Mon Aug 30 1999 - 22:45:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US