Home » Server Options » Text & interMedia » How to search the word in pdf/word document
How to search the word in pdf/word document [message #291042] Wed, 02 January 2008 17:13 Go to next message
amjathkhan.subhankhan
Messages: 9
Registered: December 2007
Location: chennai
Junior Member
Hi,
i have uploaded the pdf, word document in Oracle BLOB data field and also created index for that BLOB field.

when i search for the particular keyword in the BLOB field by using this statement
SELECT *
FROM fnd_lobs
WHERE dbms_lob.instr(FILE_DATA,utl_raw.cast_to_raw('OCM'))>0
it returns the result perfectly.

but when i tried with CONTAINS() function it does not return the result.

SELECT *
FROM fnd_lobs
WHERE contains(FILE_DATA,'OCM')>0

please help me to fix the issue.

Thanks,
Amjad Khan
Re: How to search the word in pdf/word document [message #291055 is a reply to message #291042] Wed, 02 January 2008 21:10 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
amjathkhan.subhankhan wrote on Wed, 02 January 2008 18:13

does not return the result.

Doesn't provide us much help.

What type of index did you create? Have you reviewed Text Application Developer's Guide?.
Previous Topic: Problem with filtering binary documents (.doc, .pdf, etc...)
Next Topic: CTXCAT / CONTEXT index
Goto Forum:
  


Current Time: Thu Mar 28 15:19:32 CDT 2024