| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
