I have a table DOCUMENTS with a BLOB column which stores MS Word documents.
I want to search for some patterns in the document. Eg., Search for all the documents which have EMPLOYEE in it.

I used the following code to index the BLOB's.

CREATE INDEX my_cv_idx ON DOCUMENTS(BLOB_CONTENT) INDEXTYPE IS CTXSYS.CONTEXT;

I could successfully create index.

After creating index, I am trying to query the table:

select ein from documents where contains(blob_content,'oracle',1)>0;

This returns me 0 rows. I am sure that the document has oracle in it.

Can any please suggest me at the earliest, the mistake i have commited.


Thanks in Advance.