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