Xml parsing failing
I am trying to execute a procedure that loads from xml files into the database tables. So far the load has been running well, but when I try to execute a particular batch that has about 10 xml files on the server, I get the following errors:
Begin XML Load...10046
/d02/staging/extracts/extractions1/1174779480419( this is the directory where file is located)
1174779480419.xml(name of XML file)
FAIL: XML Parse Failure...1174779480419.xml
ERROR: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML
processing
LPX-00216: invalid character 11 (0xB)
Error at line 1
I am in OTHERS Exception Block....ORA-29284: file read error
ORA-06512: at
"SYS.UTL_FILE", line 262
ORA-06512: at "SYS.UTL_FILE", line 1139
ORA-06512: at
"HLPR.PROC_XML_LOAD", line 1225
ORA-31011: XML parsing failed
ORA-19202: Error
occurred in XML processing
LPX-00216: invalid character 11 (0xB)
Error at line 1
Any thoughts on debugging this?