From MohanR@STARS-SMI.com Thu, 27 Dec 2001 14:35:41 -0800
From: "Mohan, Ross" <MohanR@STARS-SMI.com>
Date: Thu, 27 Dec 2001 14:35:41 -0800
Subject: RE: Firing order of triggers
Message-ID: <F001.003E3778.20011227141527@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: RE: Firing order of triggers



<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@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@city.coquitlam.bc.ca">mailto:dbrowett@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@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@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@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).