Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> mutating table error - trigger order
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
![]() |
![]() |