RE: Firing order of triggers

Thanks for all the responses,

It turns out two of the triggers are from the vendor (database supports a maintenance management system)
and the third is one of ours.

The trigger in question (the third one) updates the data for accounting purposes before it gets moved
(one of the other trigger) to an interface table for transfer to Peoplesoft.

Two weeks ago the trigger worked fine, then we updated a totally different procedure, and to put it into
production, the configuration process reloads/recompiles ALL triggers/procedures in the database, and now it fires differently.

It also turns out that one of the vendors triggers has a "user exit" which we are going to take advantage
of and merge our trigger into one of theirs.

I agree it would make sense to merge all the triggers together, at least we can do 2 out of 3.

-----Original Message-----
Sent: December 27, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L

Darren,

I may be missing something, but since you want all three to fire on the same event, and you also want them to fire in a particular order, why not put them all in the same trigger with logic to control the order?

-Ron-

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Joe Testa
> Sent: Thursday, December 27, 2001 5:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Firing order of triggers
>
>
> nope
>
> joe
>
>
> Browett, Darren wrote:
>
> > 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
> >
> ------------------------------------------------------------------
> ----------
> > -----------------------------------------------
> >
> >
> >
>
>
> --
> Joe Testa, Oracle DBA
> Want to have a good time with a bunch of geeks? Check out:
> http://www.geekcruises.com/standard_interface/future_cruises.html
> I'm presenting, when registering drop my name :)
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
> INET: teci_at_the-testas.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron  Yount
  INET: ronwy_at_swbell.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).
-- 
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).