DBMS_XSLPROCESSOR.ValueOf Returns ORA-24331 (Doc ID 3002113.1)

Last updated on FEBRUARY 08, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.21.0.0.0 and later
Information in this document applies to any platform.

We need to consume a SOAP-Service, returning a XML document.

The dbms_xslprocessor.valueOf function returns the following error stack, because the node value exceeds the 32k limit of VARCHAR2:

ORA-24331: user buffer too small

ORA-06512: at "XDB.DBMS_XSLPROCESSOR", line 785

ORA-06512: at "XDB.DBMS_XSLPROCESSOR", line 811

ORA-06512: at "XDB.DBMS_XSLPROCESSOR", line 819

ORA-06512: at "GENERIC.GENERIC_WEB_SERVICES", line 1538

ORA-06512: at "GENERIC.GENERICTESTGETDOCUMENTS", line 62

ORA-06512: at line 3

24331. 00000 - "user buffer too small"

*Cause: The user buffer to contain the output data is too small.

*Action: Specify a bigger buffer.

We need the complete value of the node, or an alternative to this function, to be able to return a CLOB.

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

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