Database Software

Hi All,

I am trying to store and search PDF files in the oracle database.
I can insert and index the PDF files just fine but cannot get any result. I always get No Rows.
Here's what I am doing and the issues I am facing.

I created a Table with fields
ID (VARCHAR)
NAME (VARCHAR)
DOC (BLOB)

I inserted the PDF file in the BLOB field through a Java program and insert worked fine as I verified by retreiving the PDF and writing to file.

I created index using following SQL:

create index my_index on PDF_TABLE(PDF_FLD) indextype is ctxsys.context
parameters ('datastore ctxsys.default_datastore
filter ctxsys.inso_filter');

The index was created successfully without any problems.

I ran query as follows and got no rows although the searched text is in PDF

SELECT SCORE(1), PDF_FLD from PDF_TABLE WHERE CONTAINS (PDF_FLD, 'Table of Cotents',
1) > 0;

I tried alternate queries as well with no luck.

Any ideas ??

Thanks