FUZZY with NEAR queries fails on 10.2.0.5 with Parse Error ORA-29902 ORA-20000 DRG-50901 (Doc ID 1367462.1)

Last updated on NOVEMBER 04, 2013

Applies to:

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

Symptoms

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

SQL> select * from ctxsys.ctx_version;

VER_DICT   VER_CODE
---------- ----------
10.2.0.5.0 10.2.0.5.0

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

Cause

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