What is mutating trigger?How to avoid it??
Answer Posted / 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 |
Post New Answer View All Answers
How can you load microsoft excel data into oracle? : aql loader
what are different types of keys in sql?
Are stored procedures faster than dynamic sql?
what is “go” in t-sql? : Transact sql
How do I debug a stored procedure?
what is a primary key? : Sql dba
What are crud methods?
Can we insert data into materialized view?
Can we perform dml on view?
How many types of indexes are there in sql?
how to shutdown mysql server? : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
How to add, remove, modify users using sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is auto increment in sql?