Oracle Text : Using Context Contains Search On Commas And Dots (Doc ID 807749.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 9.2.0.1 to 11.1.0.7 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 01-Oct-2013***


Symptoms

You want to make sure that commas "," and dots "." are part of your search, but you get error when you use them in the contains function.

This query:

select TITLE from TABLE_CONTEXT WHERE
contains(NBR_TITLE_NICKNAME,'SYSTEMS%',1) > 0;

Returns:

TITLE
---------------------------------------------------------------
75280063 752-80063 BEA SYSTEMS, INC BEA SYSTEMS INC
75280137 752-80137 CREDENCE SYSTEMS GMBH CREDENCE SYSTEMS, GMBH

When using the comma in the contains function we get:

select TITLE from TABLE_CONTEXT WHERE
contains(TITLE,'SYSTEMS,%',1) > 0;

select TITLE from TABLE_CONTEXT WHERE contains(TITLE,'SYSTEMS,%',1)
> 0
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms

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