ORA-22921 Could be Generated When Calling DBMS_LOB.READ With an xmltype Column Stored as CLOB (Doc ID 2881142.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

After the Database was migrated from 12c to 19c, when calling the DBMS_LOB.READ procedure with an XMLTYPE stored as CLOB on a 19c Database using a multibyte character set such as AL32UTF8 an "ORA-22921 - length of input buffer is smaller than amount requested" error code may be generated.

Sample code:

Above code may generate errors like:

ERROR at line 1:
ORA-22921: length of input buffer is smaller than amount requested
ORA-06512: at "SYS.DBMS_LOB", line 1081
ORA-06512: at line 17

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.