DevOps, CI/CD and Automation

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 3.1.07.42
Versioning Support 3.1.07.42


My database version is below.

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 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,