FOR UPDATE的语句贴出来看看 目标表有过用了别名把别名去掉试试 如果数据中有特殊符号看看是不是需要转换
pkg com.sinocc.pm.ecmman.CPCECNFunc.doupdatecpcdrawingparamsins(<objid>) pkg com.sinocc.docmanager.CPCDocWFFunc.mergeDocNoSynModel("select distinct olddrawid || '_' ||oldrev targetdocid,newdrawid || '_' || newrev historydocid,2 as mergetype,1 as keeptwfobj,usesourcedocname from cpcecndrawline where olddrawid<>'0' and drawoperation=1 and cpcecndrawline.ecnid in (select ecnid from cpcecn where wfid=<wfid>)") update cpcecndrawline set newdrawid=docid,newrev=rev,newdrawname=docname from cpcdoc where cpcdoc.docid=cpcecndrawline.olddrawid and cpcecndrawline.ecnid in (select ecnid from cpcecn where wfid=<wfid>) and olddrawid<>newdrawid and olddrawid<>0 and drawoperation=1 pkg com.sinocc.psmanager.intf.CPCPdmIntfWfFunc.drawintf("select b.olddrawid objid,b.oldrev objrev,6 reftype,a.newdrawid refid,a.newrev refrev,1 as act from cpcecndrawline a, cpcecndrawline b where a.ecnid=b.ecnid and a.superitemid=b.drawitemid and a.drawoperation=2 and a.ecnid in (select ecnid from cpcecn where wfid=<wfid>) union select b.olddrawid objid,b.oldrev objrev,6 reftype,a.olddrawid refid,a.oldrev refrev,2 act from cpcecndrawline a,cpcecndrawline b where a.ecnid=b.ecnid and a.superitemid=b.drawitemid and a.drawoperation in (3,8) and a.ecnid in (select ecnid from cpcecn where wfid=<wfid>)") pkg com.sinocc.pm.ecmman.CPCECNFunc.doupdatedrawid(<objid>)
ORA-01480: trailing null missing from STR bind value Cause: A bind variable of type 5 (null-terminated string) does not contain the terminating null in its buffer. Action: Terminate the string with a null character
目标表有过用了别名把别名去掉试试
如果数据中有特殊符号看看是不是需要转换
pkg com.sinocc.docmanager.CPCDocWFFunc.mergeDocNoSynModel("select distinct olddrawid || '_' ||oldrev targetdocid,newdrawid || '_' || newrev historydocid,2 as mergetype,1 as keeptwfobj,usesourcedocname from cpcecndrawline where olddrawid<>'0' and drawoperation=1 and cpcecndrawline.ecnid in (select ecnid from cpcecn where wfid=<wfid>)")
update cpcecndrawline set newdrawid=docid,newrev=rev,newdrawname=docname from cpcdoc where cpcdoc.docid=cpcecndrawline.olddrawid and cpcecndrawline.ecnid in (select ecnid from cpcecn where wfid=<wfid>) and olddrawid<>newdrawid and olddrawid<>0 and drawoperation=1
pkg com.sinocc.psmanager.intf.CPCPdmIntfWfFunc.drawintf("select b.olddrawid objid,b.oldrev objrev,6 reftype,a.newdrawid refid,a.newrev refrev,1 as act from cpcecndrawline a, cpcecndrawline b where a.ecnid=b.ecnid and a.superitemid=b.drawitemid and a.drawoperation=2 and a.ecnid in (select ecnid from cpcecn where wfid=<wfid>) union select b.olddrawid objid,b.oldrev objrev,6 reftype,a.olddrawid refid,a.oldrev refrev,2 act from cpcecndrawline a,cpcecndrawline b where a.ecnid=b.ecnid and a.superitemid=b.drawitemid and a.drawoperation in (3,8) and a.ecnid in (select ecnid from cpcecn where wfid=<wfid>)")
pkg com.sinocc.pm.ecmman.CPCECNFunc.doupdatedrawid(<objid>)
Cause: A bind variable of type 5 (null-terminated string) does not contain the terminating null in its buffer.
Action: Terminate the string with a null character
或者用sqldeveloper