Hi Jared, wasn't that 'unpredictable firing order of triggers of the same type'?
Greetings, Guido >>> [EMAIL PROTECTED] 23.09.2003 23.44 Uhr >>> See http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c18trigs.htm#981 At one time, the firing order of triggers was not predictable. Not sure when that changed. A Joshi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/23/2003 12:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: ** trigger behaviour Hi, I have a table which has three triggers : 1) before update - statement 2) after update - on each row 3) after update - statement I assume the order of execution is 1,2 then 3. Does it do any processing in parallel? Is it safe to assume that after the last line on trigger 2 it will execute the first line on trigger 3? I am seeing some processing after end of trigger 2 and begin of trigger 3 and cannot trace it. Anyone else has any similar experience? Thanks Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
