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

Thread: Mutating table?

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Unhappy

    Hi,
    I need to make a select from a row trigger on Insert from the same table. Is anybody knows how to avoid mutating in this case?
    Thanks a lot!

  2. #2

    Use a package variable

    The solution is to use two triggers: The row level trigger inserts the values into a plsql-table in a package, the statement level trigger then loops through and performs the selects that you need doing: tables are only mutating at row-level triggers.

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Thank you!!!

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