Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> mutating table error - trigger order

mutating table error - trigger order

From: robert <gnuoytr_at_rcn.com>
Date: 25 Jul 2003 13:44:08 -0700
Message-ID: <da3c2186.0307251244.5ee815fe@posting.google.com>


found the threads on mutating table error. coded the fix as shown, but now puzzles me: if, as is oft stated, trigger order for same type trigger is not defined, then how does this technique manage to work, since there are two AFTER triggers? does the COUNT reference in the (logically) second trigger force the counter setting trigger to go first? or is it just dumb luck?

thanks,
robert Received on Fri Jul 25 2003 - 15:44:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US