CREATE OR REPLACE TRIGGER tri_xxx_ad AFTER DELETE ON xxx.xxxx FOR EACH ROW DECLARE BEGIN -- 添加跟踪数据 INSERT INTO xxx.xxx_trace (x, x, x, x, x, x, x, x, x, x, x, x) SELECT xxx_s.NEXTVAL, :OLD.x, :OLD.x, :OLD.x, :OLD.x, x, x, :OLD.x, :OLD.x, :OLD.x, :OLD.x, x FROM dual; -- 更新 UPDATE xxxx.xxxx SET x = 0, last_updated_date = SYSDATE WHERE xx = :OLD.xx;END;
1 你如何判读数据没了了 也许是被update了 不是被delete了 所以没记录 2 查看你的trigger是否还有效 user_trigger status
AFTER DELETE ON xxx.xxxx
FOR EACH ROW
DECLARE
BEGIN
-- 添加跟踪数据
INSERT INTO xxx.xxx_trace
(x,
x,
x,
x,
x,
x,
x,
x,
x,
x,
x,
x)
SELECT xxx_s.NEXTVAL,
:OLD.x,
:OLD.x,
:OLD.x,
:OLD.x,
x,
x,
:OLD.x,
:OLD.x,
:OLD.x,
:OLD.x,
x
FROM dual; -- 更新
UPDATE xxxx.xxxx
SET x = 0, last_updated_date = SYSDATE
WHERE xx = :OLD.xx;END;
2 查看你的trigger是否还有效 user_trigger status