Re: Trigger interplay

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 23 Oct 2001 21:59:24 +0200
Message-ID: <ttbjjbignbpe9e@corp.supernews.com>

"Mia" <mmiaa_at_home.com> wrote in message news:3BD59FB6.C4ECF89C_at_home.com...
> I have an update trigger on table A that prevents a column from being
> changed. I have another trigger on table B that in some cases needs to
> update a column on table A (the very value the first trigger protects).
>
> How can I handle this? Can trigger A include some logic so that it
> "knows" when the update is coming from trigger B, and thus allow it?
>
> TIA,
> -Mia
>

Sure
Create a package
Define a variable in the package spec.
This variable will determine from which source the update is coming. So, trigger B has to modify the variable, before trigger A fires.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 23 2001 - 14:59:24 CDT