oracle中写触发器
钢蛋J 2018-08-02 10:52:15 oracle中写行级触发器,触发器都生成了,但是在使用的时候报触发器未生效;
CREATE
OR REPLACE TRIGGER ZDRCFQ AFTER INSERT ON RY_ZDRKXX FOR EACH ROW
WHEN ( NEW.GKZTDM = '3' AND NEW.CZBS < '3' AND NEW.GMSFHM IS NOT NULL )
BEGIN
INSERT INTO RY_BQB ( BQBH, RYBH, GMSFHM, XXBH, XXLB, RYBQDM, BZ, CZDW,CZR, CZSJ, CZBS, RYBQLB )
VALUES
(
(SELECT sys_guid () FROM dual ),: NEW.RYBH,: NEW.GMSFHM,: NEW.ZDRKBH,
'重点人口',
'01',: NEW.BZ,: NEW.CZDW,: NEW.CZR,: NEW.CZSJ,: NEW.CZBS,
'0'
);
END;
第一次写oracle触发器。大神帮我看看有什么错