CTXCAT problem on 9I

Hi

 I use Oracle 9.2.0.1.0 on a Windows 2000.

 I have a problem I don't have on oracle 8i.

I have a table created using the following command : CREATE TABLE LEXIQUE_PLEIN_TEXTE(
    LEX_ID NUMBER(15, 0) NOT NULL,
    VALUE CLOB ,
    LEX_NOM VARCHAR2(30) NOT NULL,
    DTY_ID NUMBER(15, 0) NOT NULL,
    CONSTRAINT PKLEXIQUE_PLEIN_TEXTE_LEX_ID PRIMARY KEY (LEX_ID)       USING INDEX TABLESPACE TS_AIRS_INDEX )
;

When I try to create an index on VALUE using the following command :

create index IDX_PLEIN_TEXTE_CTXCAT on LEXIQUE_PLEIN_TEXTE(VALUE)  indextype is ctxsys.ctxcat;

I have this error :

*
ERROR at line 1:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10509: invalid text column: VALUE
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.CATINDEXMETHODS", line 100 

Is it because VALUE is a CLOB ( I have the same command on a VARCHAR2 column and it works both on 8i and 9i ) ?

This command works on 8i even if VALUE is a CLOB.    

 Thanks for your answer.

  Jean-Paul Genty Received on Sun Jul 27 2003 - 15:53:21 CEST