ORA-04091 table string.string is mutating, trigger/function may not see itCause: A trigger (or a user defined PL/SQL function that is referenced in this statement) attempted to look at (or modify) a table that was in the middle of being modified by the statement which fired it.Action: Rewrite the trigger (or function) so it does not read that table.这是错误信息和原因及解决办法. 你的触发器是在更新表后触发.可以把你的需求说一下.大家帮你改一下.
update employee set age=age+10; 改为 update employee set age=new.age+10;
create or replace trigger uee after insert or update on employee for each row begin :new.age=:new.age+10; end uee;
trigger不可以異動臟表(或異動表)的數據!!! trigger所依附的表即為臟表!!!!
create or replace trigger uee after insert or update on employee for each row begin :new.age:=:new.age+10; end uee; /
你的触发器是在更新表后触发.可以把你的需求说一下.大家帮你改一下.
改为
update employee set age=new.age+10;
after insert or update on employee
for each row
begin
:new.age=:new.age+10;
end uee;
trigger所依附的表即為臟表!!!!
after insert or update on employee
for each row
begin
:new.age:=:new.age+10;
end uee;
/