| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
