Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

WHAT IS THE FORWARDREFERENCE IN PL/SQL?

4 Answers   IBM,


WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

3 Answers  


In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 Answers  


why do we go for oracle apps technical other than sap and other packages?

2 Answers  


in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,


How many schemas we have? how many you have used?

0 Answers  


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

2 Answers   IBM, TCS,


We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,


Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,


in ap_terms table what data will be stored

2 Answers   Wipro,


where the accounting related data is stored ?

2 Answers  


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

2 Answers   IBM,


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)