Hi,
We are getting xml data as file from external sources and importing this in our Oracle Database by reading the file via bfilename. We received a data that has an invalid character which caused an error. A sample data screenshot is shown below.
Converting this to XMLTYPE after reading the file as CLOB returns the following error.
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 5
LPX-00217: invalid character 15712190 (U+EFBFBE)
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1
31011. 00000 - "XML parsing failed"
*Cause: XML parser returned an error while trying to parse the document.
*Action: Check if the document to be parsed is valid.
Is there a way to fix this?
Correction on my original post: We are using bfilename to open the file instead of utl_file package (which I originally stated). Not sure if it makes a difference.