Home » Developer & Programmer » JDeveloper, Java & XML » Error while parsing XML file with special characters (Oracle10g , Linux )
Error while parsing XML file with special characters [message #544993] Sun, 26 February 2012 03:51 Go to next message
Messages: 21
Registered: March 2007
Junior Member
Hi Gurus,

I have encountered the below error while parsing the xml file with special characters, please help me out if you have any work round for the same.

ORA-19202: Error occurred in XML processing
LPX-00216: invalid character 239 (0xEF)
Error at line 298
ORA-06512: at "SYS.XMLTYPE", line 5

Version Details :

Oracle Database 10g Enterprise Edition Release - 64bi
PL/SQL Release - Production
CORE Production
TNS for Linux: Version - Production
NLSRTL Version - Production

Re: Error while parsing XML file with special characters [message #544996 is a reply to message #544993] Sun, 26 February 2012 04:09 Go to previous message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

I remember we had a discussion about this kind of issue in the XML forum where I move this topic.
I have no time to search for it, please do so.

Previous Topic: help with xmlagg
Next Topic: How to get the metadata (in xml format) of all the fileds in SQl query ?
Goto Forum:

Current Time: Sun Aug 07 17:37:45 CDT 2022