Re: firing of triggers

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 24 Nov 2000 18:47:22 +0100
Message-ID: <8vm9h7$4sl0n$8@ID-62141.news.dfncis.de>

Oracle doesn't guarantee the order in which triggers fire. So having multiple triggers firing on the same event should be avoided.

Hth,

Sybrand Bakker, Oracle DBA

"Carl Hathaway" <chathaw2_at_ford.com> wrote in message news:8vlt91$jt04_at_eccws12.dearborn.ford.com...
> If i have two triggers that both fire on insert to a table, which gets
fired
> first?
>
> e.g CREATE OR REPLACE TRIGGER tbl_TRIGGER1
> BEFORE INSERT
> ON tbl
> ..........
> CREATE OR REPLACE TRIGGER tbl_TRIGGER2
> BEFORE INSERT
> ON tbl
> ...........
>
> Assuming that the triggers did fire in sequence, can I prevent trigger2
from
> firing if trigger1 contains a conditional clause that fails and which
would
> therefore prevent the insert from taking place.
>
> Regards
> Carl
>
>
Received on Fri Nov 24 2000 - 11:47:22 CST