www.webdeveloper.com
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Feb 2004
    Location
    Brasil porto Aelgre
    Posts
    544

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

    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 )

  2. #2
    Join Date
    Apr 2009
    Posts
    1

    About labels

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles