Re: * HELP * - Using :NEW in a trigger

In article <3idlkn$3ks_at_alterdial.UU.NET> Morgan Skinner <morgan_at_odo.fisons-lims.com> writes:
>From: Morgan Skinner <morgan_at_odo.fisons-lims.com>
>Subject: Re: * HELP * - Using :NEW in a trigger
>Date: 21 Feb 1995 21:23:35 GMT
 

>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.

This isn't possible (at least if it is, I'd like to know!). Nor is it possible to pass a record declared as <table>%ROWTYPE to another procedure or function. That is, I haven't been able to do it yet.

Spencer Moore Received on Wed Feb 22 1995 - 17:31:37 CET