Re: ** trigger behaviour
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
Re: ** trigger behaviour
I think you might be referring to this footnote, from the same document: NOTE: Although triggers of different types are fired in a specific order, triggers of the same type for the same statement are not guaranteed to fire in any specific order. For example, all BEFORE row triggers for a single UPDATE statement may not always fire in the same order. Design your applications so they do not rely on the firing order of multiple triggers of the same type. Brian - Original Message - Date: Tuesday, September 23, 2003 4:44 pm > 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: 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).
Re: ** trigger behaviour
Yup, that was it. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 03:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: ** trigger behaviour I think you might be referring to this footnote, from the same document: NOTE: Although triggers of different types are fired in a specific order, triggers of the same type for the same statement are not guaranteed to fire in any specific order. For example, all BEFORE row triggers for a single UPDATE statement may not always fire in the same order. Design your applications so they do not rely on the firing order of multiple triggers of the same type. Brian - Original Message - Date: Tuesday, September 23, 2003 4:44 pm > 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: 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).
Antw: Re: ** trigger behaviour
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).