trigger問題
我建立trigger如下:
CREATE OR REPLACE TRIGGER ECS_SFIS_OQC_SNINFO_ID
AFTER INSERT
ON ECS_SFIS_OQC_SNINFO
REFERENCING
NEW AS NEW
OLD AS OLD
FOR EACH ROW
DECLARE
oqcno VARCHAR2(16);
sncount NUMBER;
BEGIN
oqcno:=:new.STROQCNO;
select count(strsn) into sncount from ecs_sfis_oqc_sninfo where strsn=:new.strsn;
if sncount=1 then
update ecs_sfis_oqc_qcnoinfo set numchecked=sncount where stroqcno=oqcno;
end if;
end;
也就是插入數據時檢查數據是不是重複,不重複更新另一個表的對應計數.但總是提示table is mutating.trigger/function may not see it.是不是不能對本表進行操作,該怎麼做可實現?