Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Query too complex

Query too complex

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Tue, 25 Jul 2000 07:02:19 -0700 (PDT)
Message-Id: <10569.112872@fatcity.com>


Hi,

I have the following when querying on an Intermedia index
MOT.WORLD:idba>/
select ID,body from iweb.template where
contains(BODY,'%{_couleurs}%',1) > 0
*
ERROR at line 1:

ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: ConText error:
DRG-50937: query too complex
DRG-50937: query too complex

We want to look for various string containing a "_" in a long field.

Anybody ?



Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50

Do You Yahoo!?
Get Yahoo! Mail Free email you can access from anywhere! Received on Tue Jul 25 2000 - 09:02:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US