Re: Searching in a BLOB Field

Yavuz Bogazci wrote:
>
> Hi,
>
> i have a BLOB Field in wich i store my MS Word an MS Excel Documents.
> My Problem is now, that i don't know how to search a textpart in my
> document in this BLOB Field. I don't know if this is the right group
> but i don't know where to begin.
>
> thanks
> yavuz bogazci

You would probably need to index it with Oracle Text (if the filters support it) and then use the "contains" clause

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"