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