我在oracle中写了自动增长的一个触发器,但是总是出现警告:触发器存在编译错误。下面是我写的触发器CREATE OR REPLACE TRIGGER "SMEOE_A_CourseType_TRIGGER" BEFORE
INSERT ON "SMEOE_A_CourseType" FOR EACH ROW
DECLARE
NEXT_ID NUMBER;
BEGIN
SELECT SMEOE_A_CourseType_INDEX.NEXTVAL
INTO NEXT_ID
FROM DUAL;
:NEW.ID:=NEXT_ID;
END;
INSERT ON "SMEOE_A_CourseType" FOR EACH ROW
DECLARE
NEXT_ID NUMBER;
BEGIN
SELECT SMEOE_A_CourseType_INDEX.NEXTVAL
INTO NEXT_ID
FROM DUAL;
:NEW.ID:=NEXT_ID;
END;
BEFORE
INSERT
ON "SMEOE_A_CourseType"
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
begin
select SMEOE_A_CourseType_INDEX.NEXTVAL into :new.ID from dual;
END;
BEFORE
INSERT
ON "SMEOE_A_CourseType"
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
begin
select SMEOE_A_CourseType_INDEX.NEXTVAL into :new.ID from dual;
END