CREATE OR REPLACE TRIGGER update_bms_ord_record
AFTER UPDATE OF status ON oms.oms_order
FOR EACH ROW
BEGIN
CASE
WHEN UPDATING('status') THEN
IF :NEW.status='SIGN' THEN
UPDATE bms_ord_record ord SET ord.Be_Sign=1,ord.sign_time=:OLD.ACTUAL_RECEIVE_TIME WHERE ord.relatebill1=:old.relatebill1;
ELSIF :OLD.status='SIGN'
UPDATE bms_ord_record ord SET ord.Be_Sign=0,ord.sign_time=NULL WHERE ord.relatebill1=:OLD.relatebill1;
END IF;
END CASE;
END;
UPDATE oms_order o SET o.status='SIGN2' WHERE o.relatebill1='50010777';
但是报错,



