Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Passing old and new from trigger to proc.
I should have been clearer - I have tried to do this without success.
I can make the process work by declaring two variables in the trigger of the same %ROWTYPE as the table being updated. I then populate the variables from OLD and NEW one element at a time and then pass the variables into a procedure. Because of the number of elements I need to assign I want to assign the full contents of OLD and NEW in one statement or else pass OLD and NEW to the procedure.
I'd be grateful for advice on how to proceed.
Simon Irvin
"Simon Irvin" <sirvin_at_synomics.com> wrote in message
news:3ad5c997_2_at_nnrp1.news.uk.psi.net...
> Is it possible to pass the complete :old and :new bind variables from a
> trigger to a procedure? I want to compare each value in the tow sets of
> data and don't want to declare each one explicitly (there are 129).
>
> Hoping someone can help
>
> Cheers
>
> Simon Irvin
>
>
Received on Tue Apr 17 2001 - 05:25:16 CDT