What is mutating trigger?How to avoid it??
Answers were Sorted based on User's Feedback
Answer / surendra reddy
Mutaing error happens with triggers. It occurs because the
trigger is trying to update a row it is currently using.
The usual fix involves either use of views or temporary
tables so the database is selecting from one while updating
the other.
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / muthukumar
In trigger when selection and insertion or updation in same
table that time the MUTATING TRIGGER occurs.
U CAN AVOID THAT PROBLEM USE Autonomous transactions .
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / megha bidve
Use autonomous transactions because is it we can use commit
inside the trigger.
Autonomous transactions allow you to leave the context of
the calling transaction, perform an independant
transaction, and return to the calling transaction without
affecting it's state. The autonomous transaction has no
link to the calling transaction, so only commited data can
be shared by both transactions.
| Is This Answer Correct ? | 3 Yes | 2 No |
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What is a dynamic query?
How do I remove all records from a table?
Is not equal in sql?
what is Complex index. how to create it?
How many rows can sqlite handle?
what is the difference between where clause and having clause? : Sql dba
What are views in sql?
How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra
How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 Answers IBM, TCS, UHD,
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
what happens if null values are involved in expressions? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)