ORA-29913: error in executing contains callout ORA-20000: Oracle Text error:
Hello Gurus,
Oracle 12102,RHEL 7
Encountering the error while running the below query. The table has no Text/Context Index on the table involved in the query. Any help in this would be greatly appreciated.
select
*
FROM pgm_rul
WHERE pgm_cde = 'APX' and rul_typ_cde = 'EML' and TST_CDE is null
and XMLEXISTS('$pgm_rul_xml//emailId[ora:contains(text(), "aarora006@bmx.org")>0]' PASSING pgm_rul_xml AS "pgm_rul_xml");
Thanks