From hamid.alavi@quovadx.com Thu, 27 Dec 2001 14:35:42 -0800 From: Hamid Alavi Date: Thu, 27 Dec 2001 14:35:42 -0800 Subject: RE: Firing order of triggers Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Firing order of triggers 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. -----Original Message-----From: Jon Baker [mailto:jcb@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 [mailto:dbrowett@city.coquitlam.bc.ca] Sent: Thursday, December 27, 2001 4:25 PM To: Multiple recipients of list ORACLE-L 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 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@city.coquitlam.bc.ca ---------------------------------------------------------------------------- ----------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren   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 -------------------------------------------------------------------- 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). 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.