LPX-00216: Help needed with finding invalid character
619721Feb 19 2008 — edited Oct 16 2009Hi there,
Since I do not have too much experience with PL/SQL functions that can handle XML content I would like to ask for help here.
I am trying to extract the value from a node in an XML document. The XML document resides in a CLOB. Most of the time everything goes fine, but sometimes I get an error message like this:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00216: invalid character 128 (0x80)
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 0
ORA-06512: at line 1
ORA-06512: at line 10
Can someone please tell me what character 128 translates to and how I can find it in the XML content or in the CLOB? How do I look up this character?
Is there an easy way to prevent this from happening by decoding characters automatically maybe in some way? I know I can do this in PHP for example when I want to convert HTML special characters to characters that are displayed correctly.
Any help is appreciated!
Kind regards,
Theo Tol