create or replace tigger BD_HD_BANK_PRODUCT_APPLYING
AFTER UPDATE of HD_APPLYING_STATUS
ON HD_BANK_PRODUCT_APPLYINGREFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
BEGIN
IF(:new.HD_APPLYING_STATUS!=:old.HD_APPLYING_STATUS) THENUPDATE hd_bank_product set hd_product_status=:new.HD_APPLYING_STATUS
where hd_id=:old.hd_product_id;为什么老是提示未说明结合变量"OLD"
AFTER UPDATE of HD_APPLYING_STATUS
ON HD_BANK_PRODUCT_APPLYINGREFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
BEGIN
IF(:new.HD_APPLYING_STATUS!=:old.HD_APPLYING_STATUS) THENUPDATE hd_bank_product set hd_product_status=:new.HD_APPLYING_STATUS
where hd_id=:old.hd_product_id;为什么老是提示未说明结合变量"OLD"
另 是trigger 不是 tigger