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 difference between API and Interface?
In support project one ticket alloted which steps follows manualy tell me ?
Do you know what are user profiles in apps. Any examples you can give?
why do we go for oracle apps technical other than sap and other packages?
in GL module specifing org_id or not?
How to find which company will be conducted Oracle appa interview? Plz help me
define steps of assigning items to an organization.
How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/
Attribute data types?
In which table or database definition we can find the link of organization and operation units.
The report output is 10 pages then how many times between pages report trigger will fire?
Challenges faced during upgradation of 11i to R12