What is mutating error ? When did it occur and give one example?What is ref cursor give me example?What is plsql table and diff between table?Is it possible to use commit in execption handler section ?

Questions by arreddy   answers by arreddy

Showing Answers 1 - 1 of 1 Answers

kailash prasad

  • Aug 21st, 2007
 

The basic reason for Mutation error is the way that Oracle manages a read
consistent view of data. The error is encountered when a row-level trigger
accesses the same table on which it is based, while executing. The table is said
to be mutating. Mutation will not occur if a single record is inserted in the
table (using VALUES clause). If bulk insertion is done or data is inserted from
another table mutation will occur


The mutating error is not only encountered during queries, but also for
insert, updates and deletes present in the trigger.

  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