Hello,

I have a very simple table, and want to create a trigger that updates
the date column entry (with the current date), whenever a row gets
modified.
Is there a simple way of fixing this, or would I have to create 3
extra triggers, a package, etc., as described in most posts about
mutating table errors?
Could you please explain to me WHY this error happens here (I have not
been able to find a clear explanation of what causes them)?


create table mvkTest
(bukva char(5),
kogda date);

insert into mvkTest
values('aaa', sysdate);
insert into mvkTest
values('bbb', sysdate);

create or replace trigger test_Trigger
after update on mvkTest
for each row
begin update mvkTest
set kogda = sysdate;
end;
/

update mvkTest
set bukva = 'ccc'
where bukva = 'aaa';

=======>>>>>>

update mvkTest
*
ERROR at line 1:
ORA-04091: table DTI.MVKTEST is mutating, trigger/function may not see
it
ORA-06512: at "DTI.TEST_TRIGGER", line 1
ORA-04088: error during execution of trigger 'DTI.TEST_TRIGGER'



Thank you,
G.


P.S. Using Oracle 9i

Dear G.
Would care to try following

create or replace trigger test_Trigger_AFTER
after insert or update on mvkTest
for each row
begin update mvkTest set :new.kogda = sysdate;
end;


because you don't RFM



"M" <greenandkind (AT) yahoo (DOT) com> wrote

Man, RFM yourself

G. you are trying to change data at the time of update. Therefore mutation

Try to use BEFORE not AFTER
It will be something

create or replace trigger test_Trigger
before insert or update on mvkTest
for each row
begin
:new.kogda := sysdate;
end;



"Vitali" <nospam (AT) spam (DOT) net> wrote