Tags: character, database, documentora-19202, error, invalid, lpx-00217, msg, mysql, ora-31154, oracle, register, ride, schema, sql, xml

LPX-00217: invalid character

On Database » Oracle

1,306 words with 3 Comments; publish: Fri, 08 Feb 2008 16:37:00 GMT; (25078.13, « »)

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

Thanks

All Comments

Leave a comment...

  • 3 Comments
    • Hi,

      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 ... ?>
      header,

      but be aware that when I tried this with UTF8 I hit a ORA-0600 error trying to register the schema.

      Regards

      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