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.

About these ads
About

C# developer, IIS master

Tagged with: , ,
Posted in Oracle

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 99 other followers

%d bloggers like this: