Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 190 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 66 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
NIRMAL KUMAR L
Rank 3 - Community Apprentice
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
0