Lpx-00209 If Xml String Contains <?Xml Version="1.0" Encoding="Utf-8"?>

(Doc ID 1330279.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
***Checked for relevance on 26-Feb-2013***


An LPX-00209 error ocuurs when processing an XML string that contains
NAMESPACES and <?xml version="1.0" encoding="UTF-8"?>.

SELECT content
 FROM ( select '
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
     my string
</soapenv:Envelope>' xml
 xmltable(XMLNAMESPACES ('http://schemas.xmlsoap.org/soap/envelope/' AS "soapenv"),
   '/soapenv:Envelope' passing xmltype(t.xml) columns
 content clob PATH 'content'
 ) c;

The execution gives:
ERROR at line 12:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00209: PI names starting with XML are reserved
Error at line 2
ORA-06512: a "SYS.XMLTYPE", line 310
ORA-06512: a line 1


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms