FUZZY with NEAR queries fails on with Parse Error ORA-29902 ORA-20000 DRG-50901

(Doc ID 1367462.1)

Last updated on NOVEMBER 04, 2013

Applies to:

Oracle Text - Version to [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 04-Nov-2013***


After upgrade from to FUZZY() with NEAR() queries fails with syntax parsing errors:

SQL> select * from ctxsys.ctx_version;

---------- ----------

SQL> select id
from idu_ident_ut
where CONTAINS(nome_completo,'near((fuzzy({Ricardo},66,,W)=Ricardo, fuzzy({miguel},66,,W)=miguel), 20, true)') > 0;
select id
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 7


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms