Hi all,
Please note, this is a similar issue to the below mentioned post.
viewtopic.php?t=155789
Am trying to read and load 2 CLOB fields, I am using LongVarchar (4000) to read and load the data, Array size is set to 1 and the columns are at the end or the Oracle connector (Target).
I am using a Update then Insert option while loading and records are getting inserted without any issues, But when a record matches the key (Update) the job fails with the below issue
ORA-22275: - invalid LOB locator specififed
-- I was able to debug and If there are nulls in the either of the CLOB fields the job aborts as above, If someone is aware of how to resolve the issue please let me know.
Note : If I use a transformer and populate the value as "NULL" (CHAR) , the job completes successfully on the update.
ORA-22275: - invalid LOB locator specififed
Moderators: chulett, rschirm, roy
Finally we were able to resolve the same.
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
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