XML Database (MOSC)

MOSC Banner

ORA-29913: error in executing contains callout ORA-20000: Oracle Text error:

edited May 5, 2020 3:00PM in XML Database (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center