oracle 10g text and context index, contains syntax error...

[amrigo]

Hi
I have created an index of context type in a clob type field to increase performance when searching the database.

For the query below i have an error message: ORA 29907 found
duplicate labels on primary invocations

What can cause this error ? how can i fix it ?

I would like more information about using a context type index in a clob field

thank´s in advance

The query :
SELECT * FROM content WHERE cod_type = '2' and (upper(title) like
upper('%testing%') OR CONTAINS (text,'testing',1)>0 OR CONTAINS
(text_c,'testing',1)>0 OR CONTAINS (text_g, 'testing',1)>0 OR CONTAINS
(text_p, 'testing',1)>0 )

[aspaiva]

Hi there. If you did not get an answer (I dont believe you didnt since 2007), I'd like to remember you can try to designate a diferent label number for each one CONTAIN clause:

SELECT * FROM content WHERE cod_type = '2' and (upper(title) like
upper('%testing%') OR CONTAINS (text,'testing',1)>0 OR CONTAINS
(text_c,'testing',2)>0 OR CONTAINS (text_g, 'testing',3)>0 OR CONTAINS
(text_p, 'testing',4)>0 )

This post is just to help people who perhaps fall in the same problem in nowadays (2009.04.03) and to register one possible answer.

Bye.