我做了个触发器,但是边缘不能通过。代码如下: CREATE OR REPLACE TRIGGER TR_MZSF_TJSF BEFORE UPDATE ON MZYS_TBS_MPRESP FOR EACH ROW DECLARE CURSOR c_tjjg_temp IS SELECT * FROM bj.tbs_bj_tjjg_temp WHERE tjxlh = :NEW.tjxlh; BEGIN FOR v_TjjgData IN c_tjjg_temp LOOP INSERT INTO bj.tbs_bj_tjjg(xlh,tjxlh,tjlbm,tjnm,ifdr,cs) VALUES(v_TjjgData.xlh,v_TjjgData.tjxlh,v_TjjgData.tjlbm,v_TjjgData.tjnm,v_TjjgData.ifdr,v_TjjgData.cs); END LOOP; END;
CREATE OR REPLACE TRIGGER TR_MZSF_TJSF
BEFORE UPDATE ON MZYS_TBS_MPRESP FOR EACH ROW
DECLARE
CURSOR c_tjjg_temp IS
SELECT * FROM bj.tbs_bj_tjjg_temp WHERE tjxlh = :NEW.tjxlh;
BEGIN
FOR v_TjjgData IN c_tjjg_temp LOOP
INSERT INTO bj.tbs_bj_tjjg(xlh,tjxlh,tjlbm,tjnm,ifdr,cs)
VALUES(v_TjjgData.xlh,v_TjjgData.tjxlh,v_TjjgData.tjlbm,v_TjjgData.tjnm,v_TjjgData.ifdr,v_TjjgData.cs);
END LOOP;
END;