5 Replies Latest reply on Aug 13, 2009 11:53 AM by mdrake-Oracle

    Error to processing special characters.

    Cheney Shue
      The DB is 11.1.0.7. It reported error to execute following script. It seems Oracle XML doesn't support the character "&". How to resolve it?

      declare
      xml XMLType;
      begin
      xml:=XMLType('<test>A&B</test>');
      end;


      Error report:
      ORA-31011: XML parsing failed
      ORA-19202: Error occurred in XML processing
      LPX-00241: entity reference is not well formed
      Error at line 1
      ORA-06512: at "SYS.XMLTYPE", line 310
      ORA-06512: at line 4
      31011. 00000 - "XML parsing failed"
      *Cause:    XML parser returned an error while trying to parse the document.
      *Action:   Check if the document to be parsed is valid.

      Edited by: Cheney Shue on Aug 11, 2009 9:21 AM

      Edited by: Cheney Shue on Aug 11, 2009 9:21 AM

      Edited by: Cheney Shue on Aug 11, 2009 9:21 AM