| 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
|
|
|
| Re: How to search the word in pdf/word document [message #291055 is a reply to message #291042 ] |
Wed, 02 January 2008 21:10  |
 |
ebrian
Messages: 1883
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?.
|
|
|
]
Members
Search
Help
Register
Login
Home
