Extracting a Text Node that is Larger than 8KB from inside a CDATA Section Produces Incorrect Result
(Doc ID 1593620.1)
Last updated on APRIL 12, 2022
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
Information in this document applies to any platform.
Extracting a text node that is larger than 8KB from inside a CDATA section produces incorrect result. Large chunks of the content are repeated.
Putting the cdata.xml to the directory and run the following SQL in SQL Developer and the output of the SQL is cdata_output.xml. The output data is duplicated.
SELECT XMLTYPE(BFILENAME('IQ_ROSE_DIR', 'cdata.xml'), nls_charset_id('AL32UTF8')).getClobVal() from dual;
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