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 JUNE 30, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 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.

Symptoms

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

SELECT
xmltype(d.dem_donnees).extract('/a:entry/a:content/div/div[@class="detailsDemande"]/span[@class="niveauGarantieAssurance"]/text()',
'xmlns:a=http://www.w3.org/2005/Atom
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance
xmlns:xhtml=http://www.w3.org/1999/xhtml').getStringVal()
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.

Changes

 

Not working testcase with NLS_CHARACTERSET WE8ISO8859P15



Cause

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
Symptoms
Changes
Cause
Solution
References


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