My Oracle Support Banner

ORA-31011 ORA-19202 LPX-00217 "XML parsing failed with Extract value from CLOB containing &#x20AC (the hexa code of Euro)" (Doc ID 1310237.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 24-Jul-2013***


Extract value from CLOB , and CLOB contain euro sign (the hexa code of euro sign ) or  character hexa code of

from demande d;

on a CLOB column (dem_donnees) containing html codes, like euro¬ produce the error below

Erreur SQL : ORA-31011: Echec d'analyse XML
ORA-19202: Une erreur s'est produite lors du traitement la fonction XML (
LPX-00217: 8364 (U+20AC) non valide
Error at line 34
ORA-06512:   "SYS.XMLTYPE", ligne 272
ORA-06512:   ligne 1
31011. 00000 - "XML parsing failed"
*Cause: XML parser returned an error while trying to parse the document.
*Action: Check if the document to be parsed is valid.



Not working testcase with NLS_CHARACTERSET WE8ISO8859P15


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.