Home » Developer & Programmer » JDeveloper, Java & XML » XML extraction and character encoding error? (Oracle 10g)
XML extraction and character encoding error? [message #301472] Wed, 20 February 2008 15:44
nancydrew
Messages: 1
Registered: February 2008
Junior Member
Hi All,


I have xml stored in an Oracle table in another database.
This is db linked to the database I am using to extract the value using extractvalue function within Oracle.
However,

select extract(xmldata,'product/@id') from prodxml;

But this is giving me the following error:

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00216: invalid character 236 (0xEC)
Error at line 1

Could it have something to do with the character encoding or xml schema registration.

ANY help is appreciated!!!
Nancydrew
Previous Topic: ORA-30625: error when running code
Next Topic: How ILoading .xml into target table
Goto Forum:
  


Current Time: Thu Mar 28 15:46:24 CDT 2024