Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Mutating Table - Update Same Table

5489Aug 15 2002
Hello,

I have case where I have a mutating table because of a trigger. Here is the case:

One record gets updated. Related records should also be updated with the same information. I create a trigger on the after update action, to update the rows in the table. But when I do this, I get the mutating table (very obvious why).

I have seen a lot of examples on how to avoid mutating tables, but all the examples I find have to do with several tables. How do I do this with one table updating itself?

Thanks, Charlie.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2002
Added on Aug 15 2002
7 comments
884 views