Oracle Trigger creation with compilation errors

Question

I am trying to create a simple trigger with following code -

CREATE OR REPLACE TRIGGER trg_menu_id BEFORE INSERT ON "menu" FOR EACH ROW
BEGIN
 SELECT
    menu_id_seq.NEXTVAL INTO : NEW.MENU_ID
 FROM
    dual ;
END ;

But I am getting - [Err] ORA-24344: success with compilation error I don't understand what I am doing wrong.

pay attention to colon before NEW. There should not be any space there. Also, is your table really named "menu" in lowercase? — micklesh
– micklesh, Commented Jun 15, 2016 at 6:27
I have also tried by removing space after colon. But same result. Yes table name is in lowercase — Md Riad Hossain
– Md Riad Hossain, Commented Jun 15, 2016 at 6:30
please post the complete error output. run : Show errors after the trigger execution to get complete output — anudeepks
– anudeepks, Commented Jun 15, 2016 at 6:49

Md Riad Hossain · Accepted Answer · 2016-06-15 07:10:26Z

1

At last my problem is solved. Field name was in small letter so I have to use NEW."menu_id" instead of NEW.MENU_ID and now it works fine!!! My new code is-

CREATE OR REPLACE TRIGGER trg_menu_id BEFORE INSERT ON "menu" FOR EACH ROW
BEGIN
 SELECT
    menu_id_seq.NEXTVAL INTO :NEW."menu_id"
 FROM
    dual ;
END ;

answered Jun 15, 2016 at 7:10

Md Riad Hossain

2915 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Oracle Trigger creation with compilation errors

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