Re: mutating table error - trigger order

On 25 Jul 2003 13:44:08 -0700, gnuoytr_at_rcn.com (robert) wrote:

>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

You need to differtiate betweeen after row triggers and after statement triggers

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jul 25 2003 - 17:17:00 CDT