Datastage：在执行时报错ORA-1405

ZY_SHUQIANXJ_V,0: The OCI function OCIStmtFetch2 returned status -1. Error code: 1,455, Error message: ORA-01455: converting column overflows integer datatype. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1,599)

datastage 列属性，插入列后若不修改列属性可空，将在执行时报错ORA-1405,非 非空字段NULL值，由于这里设置非空，将出此错。

 

 

 

 

ZY_SHUQIANXJ_V,0: The OCI function OCIStmtFetch2 returned status -1. Error code: 1,457, Error message: ORA-01457: converting column overflows decimal datatype. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1,599)

 

 

 

 

 

 

JY_JIANYANBGMX_V,0: While reading data for column JIANYANMXID, the connector received Oracle error code ORA-1406. (CC_OraStatement::logArrayReturnCodes, file CC_OraStatement.cpp, line 6,449)

 

 

 

手工添加的字段列，没有在sql脚本中添加报下面错

 

-----------------------------------------

ZY_JIEDUANXJ,0: The OCI function OCIStmtExecute returned status 1. Error code: 1461, Error message: ORA-01461: can bind a LONG value only for insert into a LONG column.

ZY_JIEDUANXJ,0: The OCI function OCIStmtExecute returned status 1. Error code: 3106, Error message: ORA-03106: fatal two-task communication protocol error.

 

源段获取的clob字段没有做截取TO_CHAR(SUBSTR(FIELD,1,2000)),写目标超出4000长度。