Question: I an trying to insert into a table
and I get this ORA-22835 error:
ORA-22835: Buffer too small for CLOB to CHAR or
BLOB to RAW
Is it true that this ORA-22835 IF GONE IN RELEASE 10.2?
Answer: The oerr utility shows this for the
ORA-22835:
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.
This issue is bug related and it is fixed in APEX 4.0.2 (RE: Bug
0150816) and in
Oracle release 10.2.
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|