Re: * HELP * - Using :NEW in a trigger
From: Morgan Skinner <morgan_at_odo.fisons-lims.com>
Date: 21 Feb 1995 21:23:35 GMT
Message-ID: <3idlkn$3ks_at_alterdial.UU.NET>
Date: 21 Feb 1995 21:23:35 GMT
Message-ID: <3idlkn$3ks_at_alterdial.UU.NET>
bill.holmes_at_gsa.gov (Bill Holmes) wrote:
>
> :new and :old enable your trigger to access column values, e.g.
> 'if :new.sal > 10000' or 'if :new.sal < :old.sal'.
Yep, I know that. What I want to do is to be able to pass the whole record to another stored procedure, where I will access any of the field values as necessary. I need to know if it is possible to pass :NEW from a trigger to another stored procedure.
Thanks in advance. Received on Tue Feb 21 1995 - 22:23:35 CET