1 Reply Latest reply on Nov 2, 2012 2:14 PM by Jason_(A_Non)

    xml parsing error while selecting whole result set for sql query

      Hi All,

      I am having xml parsing error while selecting whole query result set. The data is coming fine for default result set of 50 rows.

      My exception is below.

      ORA-31011: XML parsing failed
      ORA-19202: Error occurred in XML processing
      LPX-00234: namespace prefix "xsi" is not declared
      Error at line 1
      ORA-06512: at "SYS.XMLTYPE", line 254
      ORA-06512: at line 1
      *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.*

      My sql query is below that is giving results for default result set of 50 rows.

      select extract(xmlType(clob_xml_colm_name), '//v2:node1//childnode/text()','xmlns:v2="namespace_url"').getStringVal()  from table_name

      My sql developer version is below.

      Java(TM) Platform     1.7.0_04
      Oracle IDE
      Versioning Support

      My database version is below.

      Oracle Database 10g Enterprise Edition Release - 64bit

      Please could any one help me urgently as the sql query is supposed to be correct as it is returning query results, but the problem happening when i try to select whole result set.

      Thanks and regards,