oracle sql developer missing on keyword

Question

I keep getting the "missing on keyword" message on the following query and I'm not sure why:

CREATE OR REPLACE TRIGGER TRG_LINE_PRODUCT AFTER INSERT UPDATE OR DELETE ON 
TBL_CH08_LINE FOR EACH ROW
BEGIN
IF INSERTING THEN UPDATE TBL_CH08_PRODUCT P SET P_QOH = P_QOH-:NEW.LINE.UNITS
WHERE P.P_CODE = :NEW.P.P_CODE;
END IF;
END;
/

Gordon Linoff · Accepted Answer · 2016-06-27 23:11:12Z

2

You are missing an OR, in fact:

CREATE OR REPLACE TRIGGER TRG_LINE_PRODUCT
    AFTER INSERT OR UPDATE OR DELETE ON TBL_CH08_LINE
-----------------^
    FOR EACH ROW

Oracle is expecting ON after the INSERT, which is why you get that particular error.

answered Jun 27, 2016 at 23:11

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

oracle sql developer missing on keyword

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related