Re: firing of triggers

Carl Hathaway wrote:
>
> 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

It is "indeterminate"....ie I think its done in OBJECT ID order - which of course change if you drop/recreate etc etc ...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"