Home > Development > ORA-31011: XML parsing failed LPX-00217: invalid character error can be a bug

ORA-31011: XML parsing failed LPX-00217: invalid character error can be a bug

 

If you get the error below:

 ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00217: invalid character

from code running on Oracle 11.2.0.2 and 11.2.0.3 and it used to work on previous versions then stop and check MOS 1391688.1. It can save you a lot of time. The reason you get this error can be bug 11877267.

 

I hit this bug on Oracle 11.2.0.3 during investigation why a PL/SQL piece of code that parses XMLTYPE was not working. The reason is the new XML parser introduced with 11.2.0.2.

You can either apply patch 11877267 or use the workaround to set back the old XML parser as of version 11.2.0.1.

alter system set event=’31156 trace name context forever, level 0×400′ scope=spfile;

 

Cheers,
Maria

 

About these ads
Categories: Development
  1. Sowmya
    February 4, 2014 at 9:02 am

    Do you have any documents showing step by step procedure to apply the patch
    11877267.Please share.
    Thanks!

  1. No trackbacks yet.

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.

%d bloggers like this: