Re: execute immediate from a procedure across a link

HiYa

[Quoted] [Quoted] further information to my problem is that it seems that the problem is related to having out parameters in a procedure (or return values in a function)

seems odd that I can do it, with a procedure that returns nothing to the RPC caller, but just goes off and does it.

I did notice that it propagates exceptions back up the line, but I'm not sure how to manage these, and if I can or can not "raise" an exception at the other server end.

anyone?

In article <bg59d2$i11$1_at_kraken.itc.gu.edu.au>, cjundieseastwd_at_powerup.com.au (obakesan) wrote:
>HiYa
>
>I'm getting an error on executing a procedure across a database link.
>
>This program encounted the following error: ORA-02064: distributed operation
>not supported
>
>I don't understand my mistake.
>
>I've got 2 databases, in one database I've got the procedure
>
>create or replace procedure dump(result out varchar2, perror out number) is
>begin
>perror := 1;
>execute immediate 'truncate table BILLY';
>exception
>WHEN OTHERS THEN
> result := 'This program encounted the following error: ';
> result := result || SQLERRM;
> -- rollback;
> perror := -1;
>end dump;
>
>then on the other database I have
>
>create or replace procedure testa(result out varchar2, errorValue out number)
>is
>begin
> sis_dump_at_oldcas(result,errorValue);
>end testa;
>
>
>begin
> -- Call the procedure
> testa(result => :result,
> errorvalue => :errorvalue);
>end;
>
>it just won't work with that execute immediate in it ....
>any thoughts?
>
>thanks
>
>
>See Ya
>(when bandwidth gets better ;-)
>
>Chris Eastwood
>
>we tend to blame others for our problems
>I think this is something we inherit from our parents
>
>please remove undies for reply
>

See Ya
(when bandwidth gets better ;-)

Chris Eastwood

we tend to blame others for our problems I think this is something we inherit from our parents

please remove undies for reply Received on Wed Jul 30 2003 - 07:02:19 CEST