oracle loder nextval,ORA-07445: 出现异常错误: 核心转储

触发器：

create or replace trigger ecology.shareinnerdocChg_TRIGGER

AFTER UPDATE OR INSERT OR DELETE ON shareinnerdoc

FOR each row

declare

MODTYPE_1       VARCHAR2(30);

DOCCREATEDATE_1 VARCHAR2(10);

DOCID           INTEGER;

begin

MODTYPE_1       := 'UPDATE';

DOCCREATEDATE_1 := '';

IF INSERTING THEN

DOCID := :new.sourceid;

ELSIF UPDATING THEN

DOCID := :old.sourceid;

ELSIF DELETING THEN

DOCID := :old.sourceid;

end if;

insert into indexupdatelog

(ID, DOCID, CTYPE, MODTYPE, CREATETIME, DOCCREATEDATE, DONEFLAG)

values

(indexupdatelog_Id.nextval,

DOCID,

'DOC',

MODTYPE_1,

TO_CHAR(sysdate, 'YYYY-MM-DD HH24:MI:SS'),

DOCCREATEDATE_1,

0);

end;

一旦执行这条语句就会报错：

update ecology.ShareinnerDoc

set sharelevel = 1

where sourceid in (159861)

and content = 31

and type = 1

and sharelevel = 2

and sharesource = 1

and not exists

(select r.requestid

from ecology.workflow_requestbase r

where r.requestid in (select c.requestid

from ecology.workflow_currentoperator c

where c.userid = 31

and c.usertype = 0

and c.isremark = 0)

and ',' || r.docids || ',' like ',' || sourceid || ',')

——————————————————————

触发器写这个。。。

and ',' || r.docids || ',' like ',' || sourceid || ',')