My Oracle Support Banner

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

Last updated on SEPTEMBER 27, 2018

Applies to:

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

Goal

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?

Solution

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
Goal
Solution


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