OraFAQ Forum: JDeveloper, Java & XML » URGENT:-XML parsing error

Home » Developer & Programmer » JDeveloper, Java & XML » URGENT:-XML parsing error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

URGENT:-XML parsing error [message #92693]

Sun, 28 November 2004 19:24

Milind Deshpande
Messages: 93
Registered: May 2004

Member

Hi All,

Here I am sending the query containing XML data.

The query is:-

select TDI.DI_ID �from TDI TDI �where TDI.DI_INFO.Extract('/DI/Isconditional/text()').getStringVal() is not null and DI_TYPE_CD <> 11004;

This query is giving me following error:-

ERROR at line 1:

ORA-31011: XML parsing failed

ORA-19202: Error occurred in XML processing

LPX-00241: entity reference is not well formed

Error at line 1

For all XML queries it is giving the same error. For the XML queries which are taking more time to execute, it gives this error.

For the XML queries which are taking less time to execute, it doesn�t give this error.

If�I run the following query it works fine

select TDI.DI_ID �from TDI TDI �where TDI.DI_INFO.Extract('/DI/Isconditional/text()').getStringVal() is null and DI_TYPE_CD <> 11004;

I dont know why it is giving error with NOT NULL condition.

Table structure:-

�Name�� Null?�� Type
�----------------------------------------- -------- ----------------------------
�DI_ID�� NOT NULL NUMBER(18)
�DI_TYPE_CD��NOT NULL NUMBER(9)
�IS_CONDITIONAL��NOT NULL CHAR(1)
�IS_CONVERTED��NOT NULL CHAR(1)
�DI_INFO��NOT NULL SYS.XMLTYPE
�CREATED_BY��NOT NULL VARCHAR2(25)
�CREATED_DATE��NOT NULL DATE
�LAST_MODIFIED_BY��NOT NULL VARCHAR2(25)
�LAST_MODIFIED_DATE��NOT NULL DATE

I have tried everything but no solution. Can anybody help me on this pls. this is urgent.

Thanks in advance

Milind.

Report message to a moderator

Previous Topic:	Java Oracle Connectivity
Next Topic:	hashtable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 18:19:03 CST 2025