OraFAQ Forum: Text & interMedia » How to search the word in pdf/word document

Home » Server Options » Text & interMedia » How to search the word in pdf/word document

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to search the word in pdf/word document [message #291042]

Wed, 02 January 2008 17:13

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

Report message to a moderator

[Message index]

		How to search the word in pdf/word document By: amjathkhan.subhankhan on Wed, 02 January 2008 17:13
		Re: How to search the word in pdf/word document By: ebrian on Wed, 02 January 2008 21:10

Previous Topic:	Problem with filtering binary documents (.doc, .pdf, etc...)
Next Topic:	CTXCAT / CONTEXT index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 12:28:10 CDT 2024