Oracle Database Discussions

We are using ATG Dynamo on ORacle 9i R2 and we are having issue when we search the text out of ATG dynamo box, getting error:
ORA-20000: Oracle Text error:DRG-10599: column is not indexed
We don't build the code as it comes with ATG dynamo JAVA code.
Any Idea?
We have already have index on DESCRIPTION column and created context index (INDEXTYPE IS CTXSYS.CONTEXT) which using oracle text and also checked that oracle text is properly configured.


CREATE TABLE PRODUCT
(
PRODUCT_ID VARCHAR2(40 BYTE) PK NOT NULL,
VERSION NUMBER,
c_DATE DATE,
S_DATE DATE,
END_DATE DATE,
DISPLAY_NAME VARCHAR2(254 BYTE),
DESCRIPTION VARCHAR2(254 BYTE),
LONG_DESCRIPTION CLOB,
)
Mostly using column in my query is product_id, DISPLAY_NAME, DESCRIPTION, LONG_DESCRIPTION.
PRODUCT_ID has pk index, DESCRIPTION has Non Unique Index and LONG_DESCRIPTION has context index.

Thanks,
Poratisp