RE: Firing order of triggers

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Thu, 27 Dec 2001 14:35:41 -0800
Message-ID: <F001.003E3778.20011227141527@fatcity.com>

<FONT face=Arial color=#0000ff
size=2>Yessss! Exactly...this is a technique known to the Oracle Cognoscenti

(you
know who you are) as <FONT
face=Arial color=#0000ff size=2>"Filing Down the Firing Pin" for automatic fire....
<FONT face=Arial color=#0000ff
size=2> 
Very
Slick, Your Bakerness.
<FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2> 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Jon Baker   [mailto:jcb_at_netsec.net]Sent: Thursday, December 27, 2001 4:36   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   Firing order of triggers
  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 [<A
  href="mailto:dbrowett_at_city.coquitlam.bc.ca">mailto:dbrowett_at_city.coquitlam.bc.ca]   Sent: Thursday, December 27, 2001 4:25 PM <FONT   size=2>To: Multiple recipients of list ORACLE-L <FONT   size=2>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 <FONT
  size=2>we can control which one fires first,second, third, ...... n th   

  Thanks
  Darren
  <FONT

  size=2>---------------------------------------------------------------------------- 
  ---------------------------------------------- 

  Darren Browett P.Eng   
       
       
       
       
        This message <FONT

  size=2>was transmitted Data
  Administrator     

       
       
        using 100% <FONT

  size=2>recycled electrons Information and   Communication Technology City of Coquitlam   P:(604)927 - 3614 <FONT
  size=2>E:dbrowett_at_city.coquitlam.bc.ca <FONT

  size=2>---------------------------------------------------------------------------- 
  ----------------------------------------------- 
  

• Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>-- Author: Browett, Darren <FONT size=2>  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 <FONT size=2>-------------------------------------------------------------------- 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:35:41 CST