TABLE SYS.UET$ IS MUTATING

[malay]

hi,
I'm getting one error message saying.
"ERROR IN TABLE UPDATE BILL_MASTR :
TABLE SYS.UET$ IS MUTATING, TRIGGER/FUNCTION MAY NOT SEE IT"
I think this is due to locking problem.
What is this exactly.
Plz. suggest me.

regards
malay

[aarroyob]

I don´t know but this maybe will help you:



goal: How to create an after trigger which referes to
the mutating table using the :new and ld variables.
fact: Oracle Server - Enterprise Edition



fix:

It is possible to use only the ld and :new variables in an FOR EACH ROW type
of trigger.
It is not possible to run SQLs on the mutating table from this kind of trigger,
so an error is erased when the trigger is run:
ORA-04091: table %s.%s is mutating, trigger/function may not see it
ORA-06512: at %sline %s
ORA-04088: error during execution of trigger '%s.%s'
.
The solution is to create two triggers on that table. One "AFTER statement> FOR EACH ROW" and one "AFTER
STATEMENT" trigger.
The triggers will run in this order:
First: AFTER FOR EACH ROW
Second: AFTER STATEMENT
In the first trigger it is necessary to put the needed ld and :new values in
a package variables (this means to create a dummy package in which header the
variables should be defined). After initializing the package's variables with
the ld and :new values from the first trigger, now it comes the second AFTER &
lt;sql statement> STATEMENT trigger in which SQL statement referencing the
mutating table can be run.
In this trigger the package variables can be used (they will remain available to
the end of the session for every PL/SQL run in this session including your
AFTER UPDATE STATEMENT trigger).


Regards

Angel

[malay]

thanx angel for quick reply.
i'll follow ur suggestions.