My Oracle Support Banner

How to detect the cause of an XML Parsing error (Doc ID 2451144.1)

Last updated on NOVEMBER 10, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Refreshing a Materialized view and xml parsing error is encountered:

Query raising error:
ORA-12008: error in materialized view refresh path
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00216: invalid character 243 (0xF3)

There is a non XML compliant character in the data being queried.  How can the character be identified so it can be removed?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.