XMLTYPE Limited to 64k But DBMS_LOB.GETLENGTH() Returns Misleading Size in 9.2 When Clob > 64k (Doc ID 421152.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 10.2.0.3 [Release 9.2 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Nov-2013***


Symptoms

-- Problem Statement:

When XML document contains an element with > 64k data then creating an XMLTYPE object in 10g results in ORA-31167.

Even though in 9.2 XMLTYPE object is created , SQLX functions truncate the data. This behaviour is noticed with Java, pl/sql and c

So creating an XMLTYPE object with text node > 64k is not supported in 10g as per below bugs

<Bug 4349179> / <Bug 3197487> CONTENT( XML DATA) GET TRUCATED WITH XMLGEN AND XMLAGG
<Bug 4377659> VALIDATING A BUG WITH NUMBER OF NODES > 64K RESULTS IN LSX-00201

This note provides a W/A on how to return XML data > 64k  prior to 10.2.0.4



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms