把引号去掉
CREATE OR REPLACE TRIGGER TR_ATTACHMENT
BEFORE INSERT ON T_ATTACHMENT
FOR EACH ROW
BEGIN
SELECT ATTACHMENT_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
CREATE OR REPLACE TRIGGER TR_ATTACHMENT
BEFORE INSERT ON T_ATTACHMENT
FOR EACH ROW
BEGIN
SELECT ATTACHMENT_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
这样改一下试试:
i number;
begin
SELECT ATTACHMENT_SEQ.NEXTVAL INTO i FROM DUAL;
:NEW.ID =: i;
end;
BEFORE INSERT ON T_ATTACHMENT
FOR EACH ROW
BEGIN
SELECT ATTACHMENT_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END TR_ATTACHMENT
我用的时候出现了却另外一个问题:
“ORA-04082: NEW 或 OLD 引用不允许在表层触发器中。”
何解?