Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Error occurs in query when we add one line in where condition

44
Views
0
Comments
NIRMAL KUMAR L
NIRMAL KUMAR L Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

Summary

Error occurs in query when we add one line in where condition

Content

Hi,

 

While adding this line in the existing query the below error occurs.

 

Line used in where statement: XMLTYPE(htd.data_cache).EXTRACT('/TRANSACTION/BUSINESSDATA/AM/TXN/EO/ActionOccurrencesEORow/ActionName/DATA/text()').getStringVal() <> ' '

 

Error message : java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.XMLTYPE", line 272 ORA-06512: at line 1

 

Please help me to solve this. I also attached the full query below.

 

Thanks and regards,

Nirmal kumar

  •  
Tagged: