Home » Developer & Programmer » JDeveloper, Java & XML » Error while parsing XML file with special characters (Oracle10g 10.2.0.4.0 , Linux )
Error while parsing XML file with special characters [message #544993] Sun, 26 February 2012 03:51 Go to next message
palanisvr
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 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - 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: 67137
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.

Regards
Michel
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: Sat May 30 11:19:24 CDT 2020