CREATE OR REPLACE TRIGGER "FE_APP5".update_certificates
AFTER INSERT OR UPDATE OR DELETE
ON CERTIFICATES_TOBORROW
FOR EACH ROW
DECLARE
cbloanFlag VARCHAR2(2);
BEGIN
IF DELETING THEN
cbloanFlag :='0';
ELSE
cbloanFlag := :old.SPFLAG;
END IF;
UPDATE CERTIFICATES_BASEINFOR SET CBLOAN= :cbloanFlag WHERE CBID= :OLD.CTCBID;
END;
/我编写了以上一段SQL ,目的是创建一个触发器来变更 CERTIFICATES_BASEINFOR
但是我执行这段SQL,oracle一直提示这句 cbloanFlag :='0'; 有 PLS-00049: 错误的赋值变量 'CBLOANFLAG'
AFTER INSERT OR UPDATE OR DELETE
ON CERTIFICATES_TOBORROW
FOR EACH ROW
DECLARE
cbloanFlag VARCHAR2(2);
BEGIN
IF DELETING THEN
cbloanFlag :='0';
ELSE
cbloanFlag := :old.SPFLAG;
END IF;
UPDATE CERTIFICATES_BASEINFOR SET CBLOAN= :cbloanFlag WHERE CBID= :OLD.CTCBID;
END;
/我编写了以上一段SQL ,目的是创建一个触发器来变更 CERTIFICATES_BASEINFOR
但是我执行这段SQL,oracle一直提示这句 cbloanFlag :='0'; 有 PLS-00049: 错误的赋值变量 'CBLOANFLAG'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货