Re: Cascading triggers

No, you can't reference table A's columns directly from a trigger on table B. What you probably could do is to move your trigger code into a package, and take advantage of the fact that package variables maintain their state throught a session.

Jonathan

On Fri, 29 Jan 1999 22:58:28 GMT, jbaker_at_powertrade.com wrote:

>I have table A on which I have an a_aiud_row trigger that contains an update
>statement for table B. Table B has b_aiud_row to update table C. My
>question: Is there any way in b_aiud_row to access a value from the updated
>row in table A? Obviously, I can access both the :NEW. and :OLD values from
>table B (as it is a ROW level trigger on table B), but I need a value from
>table A.
Received on Sat Jan 30 1999 - 19:11:51 CST