ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion

admin

ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
(actual: string, maximum: string)
Cause: An attempt was madeto convert CLOB to CHAR or BLOB to RAW, where
the LOB size was bigger than the buffer limit for CHAR and RAW types. Note that
widths are reported in characters if character length semantics are in effectfor the
column, otherwise widths are reported in bytes.
Action: Do one of thefollowing:
1. Make the LOB smaller before performing the conversion, for example, by using
SUBSTR on CLOB
2. Use DBMS_LOB.SUBSTR to convert CLOB to CHAR or BLOB to RAW.