全部博文
-
编辑 删除
@@ 郁闷 . ORACLE的触发器报错请大家帮助,该怎么处理
CREATE OR REPLACE TRIGGER MSGTEST.UPDATEOWNERAFTER INSERT ON MSGTEST.FLOW_INSTANCE FOR EACH ROWDECLARE TMPPROCESSID VARCHAR2(30):=NULL ; TMPFLOWID VARCHAR2(30):=NULL;BEGIN SELECT PROCESS_INS_OID INTO TMPPROCESSID,FLOW_INS_OID INTO TMPFLOWID FROM FLOW_INSTANCE WHERE eventid:=old.eventid and PROCESSID in ("PR010","PR011","PR012","PR013","PR026","PR027") and OWNER in ("00120000","00120008","HOGM0001","T2209") and status = 1 and (SELECT cost_center FROM MSGTEST.org_position WH
