Re: mutating table error - trigger order

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<j1b3ivo36ran5lq9n4mshlc4fffm0k4fok_at_4ax.com>...

page 371-372 of oracle/nutshell <G>

robert

> 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 Sat Jul 26 2003 - 10:22:10 CDT