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
|
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
