Re: Can :OLD, :NEW be passed to a proc as two rows ...

Hi Daniel,

I'm creating a value-based auditing trail and I don't want to repeat the same logic in each trigger. Instead I want to centralize that logic in one generic-type procedure with the firing trigger passing in the :OLD and :NEW as two records ... ie ...%ROWTYPE.

Domenic.

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1083776720.371758_at_yasure>...
> 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?
Received on Wed May 05 2004 - 22:44:14 CDT