sql - 错误 (5) : PLS-00801: internal error [ph2csql_strdef_to_diana:bind]

Question

运行以下语句时，我在使用 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;

错误是:

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;

删除冒号 ( : ) 和 NEW 之间的空格.