Oracle string processing functions

Ora-22835: buffer to small for clob to Char or blob to raw conversion (actual string, maxinum 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 login Ming the conversion, for example, by using substr on clob

2. Use dbms_lob.substr to convert clob to Char or blob to raw.

 

In this case, generally use to_char (substr (XXX, 1, length) for conversion, directly use to_char for conversion will report a ora-22835 error!

Length is optional. It is the number of characters to extract. If this parameter is omitted, substr will return the entire string.
When length () is used to query the length of a string, the number of strings is counted, not the number of bytes.

 

In Oracle, varchar2 and char can store 8000 bytes in length. If the conversion exceeds this limit, an error occurs.