I am getting the error below. We discovered that extended ASCII characters were causing the problem. Can the insert statement below be modified to remove any character above ASCII 126 so the file can be inserted into the table? thanks
Error Loc: 300
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00200: could not convert from encoding UTF-8 to US-ASCII
Error at line 97 - Error inserting the VOLOTEA_transfer_order_20161205154001.xml file for processing
insert into AMOS_TRANSFERORDER_XML
values (1
,xmltype(
bfilename( 'XML_DIR','VOLOTEA_transfer_order_20161205154001.xml')
,nls_charset_id('AL32UTF8')
)
)