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 Error

MuzzJul 11 2015 — edited Jul 13 2015

Hi Gurus

I have a question and as per my knowledge I got the answer from Google but there are lots of  different answers exist in internet so I'm not sure about my answer, I appreciate if some look into this and correct me if you find me wrong.

What is Mutating Error?

   It means that there is some wrong logic in your coding, this type of error come up when you have a trigger that is   trying to  query or manipulate same table in which that same trigger associated with…

How to resolve

Through Materialized View (don't know the reason)....

Example

Appreciate if someone provide me simple example????

Regards

Muzz


This post has been answered by PHK on Jul 11 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2015
Added on Jul 11 2015
8 comments
1,189 views