执行:
CREATE OR REPLACE TRIGGER MACHINETYPES_TRIGGER
BEFORE INSERT ON WS2_RP_MACHINETYPES
FOR EACH ROW
BEGIN
SELECT MACHINETYPES_SEQUENCE.NEXTVAL INTO :NEW.ID FROM SYS.DUAL;
END
报错:“ORA-04098: 触发器‘MACHINETYPES_TRIGGER’无效且未通过重新确认”。
原因:没有在END后面添加“;”号。
执行:
CREATE OR REPLACE TRIGGER MACHINETYPES_TRIGGER
BEFORE INSERT ON WS2_RP_MACHINETYPES
FOR EACH ROW
BEGIN
SELECT MACHINETYPES_SEQUENCE.NEXTVAL INTO :NEW.ID FROM SYS.DUAL;
END;
//----成功。