Error occurs in query when we add one line in where condition
Summary
Error occurs in query when we add one line in where conditionContent
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:
0