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 |
In which table or database definition we can find the link of organization and operation units.
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
How to attach the multiple templates in XML Pub Report?
where u do setup of operating unit?
In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??
what is meant by lexical parameter
What are documents and test cases u followed.
in procedure how to return a value
Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?
what type of testing u r doing?
What is set function in sql .E.g.What is difference between union and union all
HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT