DBMS_XMLGEN.CONVERT Function Generates Corrupted Output For Text With Non-ASCII Symbols
Last updated on DECEMBER 05, 2016
Applies to:Oracle Database - Standard Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
DBMS_XMLGEN.CONVERT function generates corrupted output when resulting xml size is greater than 256K
* Database is using AL32UTF8 character set.
* Generated output has size of more than 128k bytes.
* Input text contains non-ASCII symbols (i.e. symbols with codes higher that 127, which are represented as multi-byte sequences in UTF-8).
Without <Patch 21424376> corrupted data is generated for all texts with size greater than 128k. If <Patch 21424376> is installed, then only data with non-ASCII symbols gets corrupted.
Here is the simple test case which demonstrates the problem - result of SQL query with non-ASCII symbols gets converted to XML text, then processed by XMLGEN and then passed to xmlparse function:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms