Re: ConText Option indexing error

Hi again,

I was able to create the ConText-Index, however, I cannot access the index:

SQL> execute ctx_ddl.create_policy('ctx_test_2', 'test.test.b' );

PL/SQL procedure successfully completed.

SQL> execute ctx_ddl.create_index('ctx_test_2');

PL/SQL procedure successfully completed.

SQL> select score(1) , a from ctx_test_2 where contains( b, 'y', 1) > 0;
select score(1) , a from ctx_test_2 where contains( b, 'y', 1) > 0 *
ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1
ORA-20000: ConText error:
DRG-10801: text query failed
DRG-11300: failed to translate query
DRG-11307: failed to parse contains()
DRG-11307: failed to parse contains()
DRG-11306: column 'B' has no indexing policy
ORA-06512: at "CTXSYS.DRUE", line 110
ORA-06512: at "CTXSYS.DR_REWRITE", line 73
ORA-06512: at "DRSYS.DR_REWRITE", line 11
ORA-06512: at line 1

This is getting more and more frustrating...

        Thank you very much for all help, Gerhard.

-- 
 Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE

OFFIS                   | | | | | |       Tel.:   0441/9722-122
Escherweg 2             | | | | | |       Sekr.:  0441/9722-113 oder -101
D-26121 Oldenburg       |O|F|F|I|S|       Fax:    0441/9722-102