XMLTYPE Limited to 64k But DBMS_LOB.GETLENGTH() Returns Misleading Size in 9.2 When Clob > 64k
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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***
-- 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
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