Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Firing order of triggers
Although there are already so many responses I would like to add one more
You can of course put all logic in one trigger and then have control over
events
Sometimes it is impossible in the trigger because there is limitation of
trigger size (32 K)
So in that case You have to put logic in packages/procedures and call them
in the appropriate order in the trigger
It is also easier to maintain such a code I think
Gints Plivna
IT Sistēmas, Merķeļa 13, LV1050 Rīga
http://www.itsystems.lv/gints/
"Kimberly Smith" To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> <ksmith2_at_myfirs cc: tlink.net> Subject: RE: Firing order of triggers Sent by: root_at_fatcity.co m 2001.12.28 00:51 Please respond to ORACLE-L
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
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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: G.Plivna_at_itsystems.lv
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Fri Dec 28 2001 - 08:33:15 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |