Hi,
Please can anybody help me to identify where is the problem, when i am trying to parse an .xml file "syntaxerror.xml', getting the following errors. I am new with xml and downloaded oracleexpress10g from OTN site.
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of '?'
Error at line 1
ORA-06512: at "XDB.DBMS_XMLPARSER", line 190
ORA-06512: at "XMLBOOK.CHECKXMLINCLOB", line 13
ORA-06512: at "XMLBOOK.CHKXML", line 10
ORA-06512: at line 2
though my xml file is free or error.
<code>
<?xml version="1.0" ?>
<CLAIM>
<CLAIMID>77804</CLAIMID>
<PAYMENT>1000</PAYMENT>
<DAMAGEREPORT>
THE INSURED
<VEHICLE MAKE="VOLKS"> BEETLE</VEHICLE>
BROKE THROUGH THE GUARD RAIL AND PLUMMETED INTO A RAVINE. THE CAUSE WAS DETERMINED TO BE
<CAUSE>FAULTY BRAKES</CAUSE>
AMAZINGLY THERE WERE NO CASUALTIES.
</DAMAGEREPORT>
</CLAIM>
</code>
procedure used to exec the file
<code>
CREATE OR REPLACE
PROCEDURE CHKXML is
xmlclob clob;
wellformed boolean;
parseerror VARCHAR2(200);
BEGIN
select xmldoc into xmlclob
from xml_documents
where docname='syntaxerror.XML';
checkxmlinclob(xmlclob, wellformed, parseerror);
if not wellformed then
dbms_output.put_line(parseerror);
end if;
END CHKXML;
</code>
Best Regards,
Abida