Home » RDBMS Server » Performance Tuning » Tuning help:-URGENT
- Tuning help:-URGENT [message #65663] Thu, 25 November 2004 19:04
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Hello Experts,

I am working on this query which is taking to much time to execute and requires to be tuned and it is giving error at the time of execution:-

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

The query is like this :-


select

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

I think the error is due to XML datatype in the Table.

Table description:-

�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

Explain plan:-

SELECT STATEMENT, GOAL = FIRST_ROWS���43638�107103�121990317��
�TABLE ACCESS FULL�ARROW�TDI�43638�107103�121990317��

Can anybody tell me what can be done in this case because Oracle doesnt allow me to create� the Index on XML datatype column.

Pls. tell me anyway that this problem can be solved.

If any table has to be created or anything you people can suggest Please this urgent.

Thanks in advance

Milind.
Previous Topic: ORA-0430 Error for SQL
Next Topic: PL/SQL commit
Goto Forum:
  


Current Time: Sat Jan 11 08:43:54 CST 2025