ORA-31011: XML parsing failed
4696Jul 23 2003 — edited Jul 27 2003Hi,
We use Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production on SUN SPARC.
Since a couple of days we got an intermitant error each time we try to extract an XML document from XML-DB as in that example:
select xdbURItype('/public/struts/menu/struts-config.xml').getClob() from dual
ERROR:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00280: HTTP error 403 Error
Error at line 2
That sort of document is not supported by a XML Schema and it is stored as a lob. We don't have the problem if the document is not XML.
First, we know that the patch for 9.2.0.3.0 may correct the problem. We didn't applied the patch yet and we are using 9.2.0.2.0 for the last 6 months without this error. So what caused that problem to appear ? We reinstalled XML-DB (catqm.sql and catxdbj.sql) without any improvement.
Second, why the XML parser is involved when we use getClob() ?