DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Mutation problem in Database Trigger

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    Post 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

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    This article should help explain it

    http://support.oracle.co.uk/metalink...T&p_id=74859.1

    Regards
    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!

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    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)
    TarryBlogging
    --- 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
  •  


Click Here to Expand Forum to Full Width