首先要确定有没有查询结果,如果有的话,再执行你触发器里的代码。
另外,触发器的代码这样改改,或许可以:
DECLARE
valcount NUMBER;
BEGIN
SELECT COUNT(*) INTO valcount FROM your_table WHERE ....。
IF valcount <> 0 THEN
FIRST_RECORD;
LOOP
IF :CON.BOX=1 AND :CON.ID IS NOT NULL THEN
DELETE FROM T_a WHERE ID = :CON.ID;
END IF;
NEXT_RECORD;
END LOOP;
COMMIT_FORM;
END IF;
END;
另外,触发器的代码这样改改,或许可以:
DECLARE
valcount NUMBER;
BEGIN
SELECT COUNT(*) INTO valcount FROM your_table WHERE ....。
IF valcount <> 0 THEN
FIRST_RECORD;
LOOP
IF :CON.BOX=1 AND :CON.ID IS NOT NULL THEN
DELETE FROM T_a WHERE ID = :CON.ID;
END IF;
NEXT_RECORD;
END LOOP;
COMMIT_FORM;
END IF;
END;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货