Mutation problem in Database Trigger
Will you please expalin me what excatly happens, when we get mutation problem --- while running triggers?
An example will be very much appreciated.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
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)
Last edited by Tarry; 11-28-2002 at 06:15 AM.
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be
Click Here to Expand Forum to Full Width