XML Parsing Error on Oracle 10g 10.2.0.5

We were getting many of these errors randomly, without any obvious pattern. On 10.2.0.4 version there didn’t exist. Finally we found a Oracle patch. After applying it, these annoying errors has gone. Patch number is

Oracle support articles [ID 9871430.8] Bug 9871430 – ORA-31011 / LPX-230 converting CLOB to XMLTYPE and Loading XML Content Fails with LPX-00230 After Upgrading the Database to 10.2.0.5 [ID 1167777.1]

Solution: Apply the patch for bug 6151936

-31011 ORA-31011: XML parsing failed

ORA-19202: Error occurred in XML processing

LPX-00230: invalid character 0 (U+0000) found in a Name or Nmtoken

Error at line 1.

-31011 ORA-31011: XML parsing failed

ORA-19202: Error occurred in XML processing

LPX-00225: end-element tag "Resolution" does not match start-element tag "ὖexecutors"

Error at line 1.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.