Hello,

Why You dont try to create this trigger
with a when clause eg:

create or replace trigger YOUR_TRIGGER before update of status on AAAA
for each row
when (new.year=old.year and new.status = 1)
begin
-- your code here
end;

Silas - [email protected]
---------------------------------------