RE: Firing order of triggers

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Thu, 27 Dec 2001 16:08:50 -0800
Message-ID: <F001.003E3815.20011227145123@fatcity.com>

Why have three triggers? I am not sure if things have changed in 9i but previously there was not way to guarantee which trigger would fire first.

-----Original Message-----
Darren
Sent: Thursday, December 27, 2001 1:25 PM To: Multiple recipients of list ORACLE-L

Happy Holidays to everybody.

We have three triggers (all BEFORE EACH ROW on INSERT ) on a table, is there anyway
we can control which one fires first,second, third, ...... n th

Thanks

Darren

Darren Browett P.Eng                                            This message
was transmitted
Data Administrator                                              using 100%

recycled electrons
Information and Communication Technology City of Coquitlam
P:(604)927 - 3614
E:dbrowett_at_city.coquitlam.bc.ca

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Browett, Darren
  INET: dbrowett_at_city.coquitlam.bc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: ksmith2_at_myfirstlink.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu Dec 27 2001 - 18:08:50 CST