ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)

ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)
Cause: An attempt was made to 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 effect for the column, otherwise widths are reported in bytes.
Action: Do one of the following:
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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-22835：缓冲区太小，不适用于CLOB到CHAR或BLOB到RAW转换（实际：字符串，最大值：字符串）,
.原因：试图将CLOB转换为CHAR或BLOB为RAW，其中LOB大小大于CHAR和RAW类型的缓冲区限制。请注意，如果字符长度语义对列有效，则宽度以字符报告，否则宽度以字节报告。,
.操作：执行以下操作之一：,
.1.在执行转换之前，使LOB更小，例如，使用CLOB上的SUBSTR,
.,
.2.使用DBMS_LOB.SUBSTR将CLOB转换为CHAR或BLOB为RAW。,
.,
.

aiaiDBA

13718043309

010-86462881

ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)

1 个回答

相似问题