Mutation table

[kiss07]

Dear daba,

Also,

WHAT IS Mutating table and what is mutating trigger?How can i
eliminate mutating trigger error?


Pls .I preparing interview. Pls some coding.

Arun..

[debasisdas]

The Oracle mutating trigger error occurs when a trigger references the table that owns the trigger.
so we ususlly get the error
ORA-04091: table name is mutating, trigger/function may not see it.

There are several causes of mutating tables, but in general a table mutation error will result if you create a trigger on a table that attempts to examine the current table. Also, the error is given when an attempt is made to examine a parent table in a cascading update/delete.

[debasisdas]

To avoid the situation u can follow these methods.

Don't use triggers - The best way to avoid the mutating table error is not to use triggers. Most of the PL/SQL developers avoid triggers unless absolutely necessary.

Use an "after" trigger - If you must use a trigger, it's best to avoid the mutating table error by using an "after" trigger, to avoid the currency issues associated with a mutating table. For example, using a trigger ":after update on xxx", the original update has completed and the table will not be mutating.

Use autonomous transactions - You can avoid the mutating table error by marking your trigger as an autonomous transaction, making it independent from the table that calls the procedure.

[debasisdas]

For further details please follow the

link

Hope that will help u.

[kiss07]

Dear deba,

Fine and thnx..

Arun..

[debasisdas]

Dear Arun

You are welcome to post more in the forum.