Hello Everybody,
Will you please expalin me what excatly happens, when we get mutation problem --- while running triggers?
An example will be very much appreciated.
Thanks
Printable View
Hello Everybody,
Will you please expalin me what excatly happens, when we get mutation problem --- while running triggers?
An example will be very much appreciated.
Thanks
This article should help explain it
http://support.oracle.co.uk/metalink...T&p_id=74859.1
Regards
Short expl.
Say you write a trigger on a dml operation of a table and in the body you perform the same trigger -- meaning carry out the same dml operation yourself, when the trigger is fired, it'll again try to fire(from the trigger body) this trigger is then a mutated trigger.
And this is cool stuff(as always)
http://asktom.oracle.com/~tkyte/Mutate/index.html