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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.