begin CREATE OR REPLACE TRIGGER ectg_del_eclmprg AFTER DELETE ON eclmprg FOR EACH ROWBEGIN UPDATE ECLMFUN SET C_PRG_ID = '' WHERE C_BRANCH_ID=:OLD.C_BRANCH_ID AND C_PRG_ID=:OLD.C_PRG_ID; END; end; SP2-0552: 未说明结合变量"OLD"
eclmprg中有C_BRANCH_ID 、C_PRG_ID这2个字段吗?
begin CREATE OR REPLACE TRIGGER ectg_del_eclmprg AFTER DELETE ON eclmprg FOR EACH ROW end; /BEGIN UPDATE ECLMFUN SET C_PRG_ID = '' WHERE C_BRANCH_ID=:OLD.C_BRANCH_ID AND C_PRG_ID=:OLD.C_PRG_ID; END; /
CREATE OR REPLACE TRIGGER ectg_del_eclmprg AFTER DELETE ON eclmprg
FOR EACH ROWBEGIN
UPDATE ECLMFUN SET C_PRG_ID = '' WHERE C_BRANCH_ID=:OLD.C_BRANCH_ID AND C_PRG_ID=:OLD.C_PRG_ID;
END;
end;
SP2-0552: 未说明结合变量"OLD"
CREATE OR REPLACE TRIGGER ectg_del_eclmprg AFTER DELETE ON eclmprg
FOR EACH ROW
end;
/BEGIN
UPDATE ECLMFUN SET C_PRG_ID = '' WHERE C_BRANCH_ID=:OLD.C_BRANCH_ID AND C_PRG_ID=:OLD.C_PRG_ID;
END;
/