Error(5): PLS-00801: internal error [ph2csql_strdef_to_diana:bind]

Question

When running the following statement I receive an error using Oracle 11g.

CREATE OR REPLACE TRIGGER autoincrement_sm_users_id BEFORE INSERT ON SM_USERS FOR EACH ROW BEGIN SELECT sm_users_id.NEXTVAL INTO : new.id FROM dual; END;

The error is:

Error(5): PLS-00801: internal error [ph2csql_strdef_to_diana:bind]

Answer 1

CREATE OR REPLACE TRIGGER autoincrement_sm_users_id BEFORE INSERT ON SM_USERS FOR EACH ROW BEGIN SELECT sm_users_id.NEXTVAL INTO :NEW.id FROM dual; END;

Remove the space between the colon (:) and NEW.