I'm having a problem with an XML parsing. I'm taking an incoming mail and using java stored in the DB i get hold of an XML attachment to an email an begin parsing it with oracle.
The problem is that when the XML file contains a euro symbol, the parser crashes. I have isolated it as being the euro € symbol, as when it is removed, the XML file is parsed perfectly. Below is the v$nls_parameters table for the database i'm using.
NLS_TIME_FORMAT HH12:MI:SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH12:MI:SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH24:MI:SSXFF TZR
Any suggestions would be greatly appreciated, and thanks in advance.