Out to resolve mutating trigger
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Out to resolve mutating trigger

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    Out to resolve mutating trigger

    Hi

    If Mutating trigger problem comes how to resolve it?
    J Gangadhar

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    For a generic question, a generic answer - change your table design.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Use Pragma Autonomous Transaction to ged rid of Mutating problem.

    Tamil

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Tamil, I'm not sure that's good general advice. You could introduce an update that could not be rolled back . . .

    ganga, if you can't redesign your tables, look here:
    http://download-west.oracle.com/docs...13trg.htm#2634

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