Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can :OLD, :NEW be passed to a proc as two rows ...
Domenic wrote:
> Hi Everyone,
>
> When a trigger is executing, it is possible to fetch all the :OLD and
> :NEW values into two records and pass them along to another procedure
> ... something like ...
>
> CURSOR c1 IS ....
> c1_rec c1%ROWTYPE ...
>
> Can a c1_rec_old and c1_rec_new be defined, opened, fetched into and
> passed to another proc as a one or two liner?
>
> I've searched the PL/SQL manual and found nothing. I don't want to
> duplicate the same code in each trigger
>
> Thanks in advance .../Domenic.
Probably ... but it seems like you are most likely misusing the trigger if that is what you are trying to do.
What is the actual business problem underlying this requrest?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed May 05 2004 - 12:05:21 CDT