mutating trigger

[ganga]

create trigger foundry_tech_ins_upd_row
after insert or update of superblock on aurora.tb_foundry_tech
for each row
when (new.superblock = 1 and new.rcctechid is null)
begin
update tb_foundry_tech set rcctechid = 1943;
end;



getting error below, How to resolve this


ORA-04091: table TB_FOUNDRY_TECH is mutating, trigger/function may not see it

[LKBrwn_DBA]

Change:

update tb_foundry_tech set rcctechid = 1943;

To this:

:new.rcctechid = 1943;