Tags: character, database, documentora-19202, error, invalid, lpx-00217, msg, mysql, ora-31154, oracle, register, ride, schema, sql, xml
LPX-00217: invalid character
I cannot get ride of this error msg when trying to register the xml schema.
Can someone help me.
ORA-31154: invalid XML document
ORA-19202: Error occurred in XML processing
LPX-00217: invalid character 0 (\u0000)
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12
ORA-06512: at line 2
Leave a comment...
- 3 Comments
I saw this error when trying to load instances in which I had defined characters in unicode that were outside
of the databases character set. In this case though, I assume this character code is the null character, which is odd.
It suggests that you have an embedded null inside of the schema document or at least in the data stream you
send to Oracle.
You could try building a database with the same character set as you define in the
?xml ... ?>
but be aware that when I tried this with UTF8 I hit a ORA-0600 error trying to register the schema.
Pete#1; Thu, 21 Feb 2008 21:30:00 GMT
- I think there are bugs with UTF8 support in 9ir2 (I had all kinds of problems). one should not use UTF8 as the DB charset at the moment.
Sam.#2; Thu, 21 Feb 2008 21:31:00 GMT
- Thanks Guys.
I found the pb. Apparently, if a < keyref> contains a value that does not reference a valid constraint name in Oracle, then LPX-00217 is raised.#3; Thu, 21 Feb 2008 21:32:00 GMT