what is mutating table and mutating error and how to solve
that?
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 |
what is unit of measure classes? give atleast two examples. name the underlying table.
In unix Schell sript what is very 1st line to be wriiten .
What is FORWARD DECLARATION in Packages?
6 Answers British Telecom BT, HCL, Tech Mahindra,
Can u define operating units inplace of inventory?
what are the tables of auto invoice.
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
How to know the number of invoices generated for one PO from front end (navigation)?
what are the different types of triggers in reports
how can we get odd numbered pages in output of a report
What is the most critical part which you had faced in your project ?
1 Answers LG, Satyam, Tech Mahindra,
what is the difference between character mode,bitmap mode
2 Answers IBM, Sierra Atlantica,
how to customize the report,please tell me customization steps