Hello DSers!!
I'm trying to update a table which has a CLOB field. (I'm quite certain the issue is because of the Oracle connector, as I have tried with the Dataset and the job ran fine).
My job is getting aborted with the following errors.
Upd_Tbl,1: The OCI function OCIStmtExecute returned status 1. Error code: 22275, Error message: ORA-22275: invalid LOB locator specified.
... UPDATE STATEMENT ..
Upd_Tbl,1: The OCI function OCIStmtExecute returned status -1. Error code: 24381, Error message: ORA-24381: error(s) in array DML. (CC_OraStatement::executeUpdate, file CC_OraStatement.cpp, line 3,163)
Please help me in resolving the same.. Thanks!
Oracle connector failure - invalid LOB locator specififed
Moderators: chulett, rschirm, roy
Supposedly the connector does that (Array size of one) if you specify the right type for the CLOB...
Is the datatype set to LongVarChar? Also - is it at the END of the column definitions? BLOBS / CLOBS must be positioned at the end in the DataStage columns, regardless of their actual position in the Oracle table.When LongVarBinary, LongVarChar and LongNVarChar link columns are used, the connector disables array processing and enforces the Array size value of 1, even if you specify small Length attribute values for those link columns.
In order to use OCI LOB locators for all LongVarchar, LongNVarchar, and LongVarBinary columns, set the CC_ORA_LOB_LOCATOR_COLUMNS environment variable to (all)
More information on https://www.ibm.com/support/knowledgece ... lumns.html
More information on https://www.ibm.com/support/knowledgece ... lumns.html