We have been getting hundreds of thousands of xml files (through AQ) from our partner (IBM Websphere MQ) for almost two years now and never had a problem. But on this Tuesday we got 6 xml files from our partner that failed due to this error:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00216: invalid character 0 (0x0)
Error at line 1
According to the Oracle doc,
Cause: An invalid multibyte character was found.
Action: Use only characters allowed by the XML specification
I googled this error and searched it on this forum. But other people who encountered this problem was because they seemed to have different NLS_LANG settings, whereas here we are both on Windows (servers and clients).
The strange thing is this: I asked our partner to email me the xml file and I copied it into a test procedure where the text is cast into an xml type and there is no problem whatsoever.
Could anyone help me on this? We are on Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 running on Windows 2003 server.