ODI File to Oracle Integration Error "ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion"
(Doc ID 2492886.1)
Last updated on OCTOBER 17, 2019
Applies to:
Oracle Data Integrator - Version 12.2.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
When integrating a CSV flat file into a table using Oracle Data Integrator (ODI) 12.2.1.x, there is a problem with a field that can potentially have values with a length over 4000 characters.
There is an initial error in the Loading Knowledge Module (LKM) execution:
ORA-01461: can bind a LONG value only for insert into a LONG column
This error is detailed in <Document 2132937.1>. However, after implementing the resolution in that note, the error changes and moves into the Integration Knowledge Module (IKM).
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4237, maximum: 4000)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |