TRIGGER AUTO_NUM_GEN编译警告：执行完成时出现警告

Question

我在oracle sql developer中使用oracle 11g express作为我的数据库运行以下语句。当我尝试创建触发器时，我只遇到问题。我得到的消息 -

TRIGGER AUTO_NUM_GEN compiled 
Warning: execution completed with warning 

的SQL-

CREATE TABLE myschema.mytable (mynums NUMBER PRIMARY KEY); 
CREATE SEQUENCE myschema.seq_of_nums MINVALUE 1 
START WITH 1 INCREMENT BY 1 CACHE 10; 
CREATE OR REPLACE TRIGGER myschema.auto_num_gen 
BEFORE INSERT ON myschema.mytable FOR EACH ROW 
BEGIN SELECT seq_of_nums.nextval INTO :new.mynums FROM DUAL; end;/

什么是我的错，为什么不工作？

我跑的诊断查询 -

show errors trigger myschema.auto_num_gen; 

而且看到 -

PLS-00103: Encountered the symbol "/" The symbol "/" was ignored 

在侧面， 当相同的代码是通过Java运行我也得到了错误 -

java.sql.SQLSyntaxErrorException: ORA-04098: trigger 
'MYTABLE.MYSCHEMA.AUTO_NUM_GEN ' is invalid and failed re-validation 

Answer 1

斜线/最后是你的敌人！删除它，代码工作！