daijinming
V2EX  ›  问与答

求教 Oracle 出发器问题,数据在插入之前 设置为 85%,语法一直过不去,求解

  •  
  •   daijinming · Oct 3, 2019 · 2135 views
    This topic created in 2602 days ago, the information mentioned may be changed or developed.
    Create or Replace trigger TOP_DISCOUNT
    Before insert on PURCHASE
    For each row
    begin
    if (:new.CLIENTNO == 24535) then 
    	:new.AMOUNT = :new.AMOUNT * 0.85;
    end if;
    end;
    

    总是报错
    [Err] ORA-24344: success with compilation error

    求解

    2 replies  •  2019-10-04 08:36:49 +08:00
    FrailLove
    FrailLove
    Oct 3, 2019 via iPhone
    1
    冒号等于
    kawowa
    kawowa
    Oct 4, 2019 via Android
    2
    当在触发条件中使用:new 或者:old 的时候注意,只能直接写 old 或者 new,不能带符号”:”否则会出错。
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2449 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 36ms · UTC 04:58 · PVG 12:58 · LAX 20:58 · JFK 23:58
    ♥ Do have faith in what you're doing.