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

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

•