daijinming
V2EX  ›  问与答

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

  •  
  •   daijinming · Oct 3, 2019 · 2123 views
    This topic created in 2598 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   ·   2091 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 572ms · UTC 08:41 · PVG 16:41 · LAX 00:41 · JFK 03:41
    ♥ Do have faith in what you're doing.