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