RE: Firing order of triggers

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Fri, 28 Dec 2001 08:10:01 -0800
Message-ID: <F001.003E3CAE.20011228072025@fatcity.com>

Actually, you bring up a good point. I never put logic in my triggers. I always
use packages. That way, you can modify one piece of logic without affecting the whole trigger. In many ways its much easier to maintain.

-----Original Message-----

G.Plivna_at_itsystems.lv
Sent: Friday, December 28, 2001 6:15 AM
To: Multiple recipients of list ORACLE-L

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

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

--

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 Lists


--------------------------------------------------------------------

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 Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message