觸發(fā)器：

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;

一旦執(zhí)行這條語句就會報錯：

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 || ',')

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

觸發(fā)器寫這個。。。

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

總結(jié)

以上是生活随笔為你收集整理的oracle loder nextval,ORA-07445: 出现异常错误: 核心转储的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。