Re: Running procedures remotely

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)_at_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)_at_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)_at_db_link;
> END;
> END-EXEC;
>
> Does all of this look reasonable?
Received on Tue Aug 31 1999 - 05:45:28 CEST