What is mutating error?when we go to mutating error in oracle?

Showing Answers 1 - 6 of 6 Answers

Ashritha

  • Sep 12th, 2011
 

it occurs when ever we try to perform either select or dml operations on the same table in the trigger created for same table

  Was this answer useful?  Yes

venugopal

  • Sep 25th, 2011
 

mutating error is nothing but when we update a table at the same time when we retrieve the data from the same table then the mutating table error occurs.......to overcome we use autonomous transaction here autonomous transaction is nothing but it is an independent transaction with out affecting the parent transaction we commit or roll back can be done in child transaction .......

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions