标题: ORA-64203: Destination buffer too small to hold CLOB data after character set... [打印本页] 作者: 曾春华 时间: 2016-9-2 09:20 标题: ORA-64203: Destination buffer too small to hold CLOB data after character set... Cause: An attempt was made to convert CLOB to CHAR, where the LOB size was
bigger than the buffer limit for CHAR types or the CHAR buffer was not big
enough to hold all data after character set conversion.
Action: Do one of the following:
* Make the LOB smaller before performing the conversion. for example, by using
SUBSTR on CLOB
* Use DBMS_LOB.SUBSTR to convert CLOB to CHAR.