RE: Firing order of triggers

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).