标题: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion [打印本页] 作者: admin 时间: 2016-9-1 08:11 标题: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion 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.