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

     Spencer.H.Moore_at_tek.com (Spencer H Moore) wrote in article Spencer.H.Moore.8.2F4B66E9_at_tek.com :
>
>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
>
I haven't tried, yet, but documentation on Packages indicates that "package variables can carry data across the boundaries of transactions since they are tied to the session". I'm not sure if this applies to database triggers but it can be applied to Forms applications or pure PL/SQL.
(See Oracle7 Server - Application Developer's Guide) Doug Berscht doug_at_atsi.com

-- 
\------------------------------------------------------------------/
|                              _/_/_/   _/_/_/_/ _/    _/ _/_/_/_/ |
|         *                   _/   _/  _/    _/ _/    _/ _/        |
|        **                  _/    _/ _/    _/ _/    _/ _/         |