RE: Firing order of triggers

From: Hamid Alavi <hamid.alavi_at_quovadx.com>
Date: Thu, 27 Dec 2001 14:35:42 -0800
Message-ID: <F001.003E3790.20011227141528@fatcity.com>

YOU
CAN DISABLED ALL 3 TRIGGERS THEN ANY TIME YOU WANT TO FIRE IT ENABLED IT SO IT THIS WAY YOU HAVE FULL CONTROL TO RUN WHICH ONE FIRST.   <FONT face=Tahoma
  size=2>-----Original Message-----From: Jon Baker   [mailto:jcb_at_netsec.net]Sent: Thursday, December 27, 2001 1: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).

The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. Received on Thu Dec 27 2001 - 16:35:42 CST