SQL> create trigger sqec_test_pk before
2 insert on test_pk for each row
3 begin
4 select squc_test_pk.nextval into:New id from dual;
5 end
创建这个触发器警告: 创建的触发器带有编译错误。
帮忙解决下了,谢谢
...全文
658打赏收藏
orcale ORA-04098: 触发器 'SCOTT.TEST_PK'
SQL> create trigger sqec_test_pk before 2 insert on test_pk for each row 3 begin 4 select squc_test_pk.nextval into:New id from dual; 5 end 创建这个触发器警告: 创建的触发器带有编译错误。 帮忙解决下了,谢谢
改为
CREATE OR REPLACE TRIGGER sqec_test_pk
before insert on test_pk for each row
DECLARE
NEXTID NUMBER;
BEGIN
SELECT squc_test_pk.NEXTVAL INTO NEXTID FROM DUAL;
:NEW.ID:=NEXTID;
END;