XMLTYPE Limited to 64k But DBMS_LOB.GETLENGTH() Returns Misleading Size in 9.2 When Clob > 64k
(Doc ID 421152.1)
Last updated on MARCH 28, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.8 to 10.2.0.3 [Release 9.2 to 10.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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
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 |
Cause |
Solution |
References |