-
Mutation problem in Database Trigger
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
sumit
-
Jim
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!
-
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
Last edited by Tarry; 11-28-2002 at 06:15 AM.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|