what is mutating table and mutating error and how to solve
that?

Answers were Sorted based on User's Feedback



what is mutating table and mutating error and how to solve that?..

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

what is mutating table and mutating error and how to solve that?..

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

what is mutating table and mutating error and how to solve that?..

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

Post New Answer

More Oracle Apps Technical Interview Questions

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  


How to attach the multiple templates in XML Pub Report?

2 Answers   Intelligroup, KPIT,


where u do setup of operating unit?

1 Answers   TCS,


In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??

1 Answers  






what is meant by lexical parameter

1 Answers   Wipro,


What are documents and test cases u followed.

2 Answers   Accenture,


in procedure how to return a value

2 Answers   Wipro,


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 ?

2 Answers   Wipro,


what type of testing u r doing?

2 Answers   Convergys,


What is set function in sql .E.g.What is difference between union and union all

2 Answers   IBM, TCS,


HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT

2 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)