My Oracle Support Banner

XML Parsing Failed With ORA-31011, ORA-19213, LPX-00290: Invalid Use Of Xmlns As A Prefix (Doc ID 2615532.1)

Last updated on JANUARY 31, 2022

Applies to:

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

Symptoms

On 18.4, an XML query fails with the following error:

ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 2
LPX-00290: invalid use of xmlns as a prefix


Statement that fails:

select XMLTransform(XMLElement("XML", XMLElement("ROW",XMLAttributes('http://www.w3.org/2001/XMLSchema-instance' as "namespace1" ,
  'http://www.w3.org/2001/XMLSchema' as "namespace2" ))), (select XMLType(xsl_template) from <table> 
  where <column> = 2642 )).getstringval() from dual


This statement executes successfully on 11.2.0.4.

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
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.