1 Reply Latest reply on Oct 23, 2009 4:17 PM by Jason_(A_Non)

    XML Parsing Error


      Getting the following error :

      ORA-31011: XML parsing failed
      ORA-19202: Error occurred in XML processing
      LPX-00217: invalid character 0 (U+0000)
      Error at line 1-31011

      I have an xml data in a clob and looks like one of the tag has a invalid character due to which the parsing fails. Anyway to get around this issue?



      l_clob CLOB;
      l_xml XMLTYPE;

      l_clob := ' <tag>
      <tag2>junk character</tag2>

      l_xml := XMLTYPE(l_clob);


      The value has is being populated into the tag1 and tag2 are coming from a oracle type that comes from a different service altogether.

        • 1. Re: XML Parsing Error
          What are you wanting to do? Do you want to remove the offending character(s) before converting to an XMLType or are you wanting to have the character become part of the XMLType message?

          The first can be solved by a REPLACE. The second involves character sets in both systems and making sure the receiving system's character is a superset or the same as the send system character set.