create or replace trigger "tri_LOG"
before insert on NL_LOG for each row
begin
select SEQ_LOG_ID.Nextval INTO :NEW.ID from dual;end tri_LOGPL/SQL 环境 ORA 8TRIGGER SA.TRI_LOG 出现符号'"'在下列需要之一时
begindeclareexitforgotoifloop
modnullpragmaraisereturnselectupdatewhile<an identifier>
<a double-quoted delimited-identifier><a bind variable><<
closecurrentdeletefetchlockinsertopenrollbacksavepointsetsql
executecommitforall<a single-quoted SQL string>select SEQ_LOG_ID.Nextval INTO :NEW.ID from dual;
:NEW.ID 是否應該為:NEW.LOG_ID ?(亂猜樓主的表字段)
create or replace trigger "tri_LOG"
before insert on NL_LOG for each row
begin
select SEQ_LOG_ID.Nextval INTO :NEW.LOG_ID from dual; end tri_LOG;
把"tri_LOG" 改成tri_LOG试试