Interested to Buy Any Domain ? << Click Here >> for more details...
what is mutating table and mutating error and how to solve
that?
- 3 Answers
- 12015 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kranthi kumar
A table which is under process of update,delete or insert
is a mutating table.
when you try to perform an action such as insert,update or
delete on that same table using a trigger then mutating
table error occurs.
if u want to solve this error then use autonomous
transaction.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / saji. sasidharan
Mutating table is the table which is being in the process
of UPDATE,DELETE or INSERT. Mutating error will happen if
try to access a mutating table. Example. Its possible to
solve using autonamous transaction.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / vijay
In row level trigger based on table, the trigger body can not read the same table data, if we try to read the same table data then we get error.
This error is called mutating error.
These table is called as mutating error.
| Is This Answer Correct ? | 0 Yes | 0 No |
please send me forms, xml pulisher questions,answers
how to avoid duplicate data while uploading data from flatfile to staging table? some validations
what is the difference between oracle 8i and 9i?
what is mean by confine mode and flexi mode?
what is the use of format trigger?a
What is oracle soa suite and what are its different components?
Give a brief overview on OrderManagement.
what is pick selection list generation report.
is it possible to run the interface without using oracle apps?
what is the error you will get if field is referenced in wrong repeating frame?
is UOM maintained at master level or organization level or both?
Is it possible to do purchase order without requisition?
Oracle Apps Technical 
