RE: Firing order of triggers

From: Jon Baker <jcb_at_netsec.net>
Date: Thu, 27 Dec 2001 14:01:24 -0800
Message-ID: <F001.003E3696.20011227133541@fatcity.com>

can you combine the code of all three into one trigger?

you can then easily programmatically determine what gets done in what order.

-----Original Message-----
From: Browett, Darren [mailto:dbrowett_at_city.coquitlam.bc.ca] Sent: Thursday, December 27, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: Firing order of triggers

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). Received on Thu Dec 27 2001 - 16:01:24 CST