Well, you may try to employ signature checks (the same
way mod_mime_magic Apache module does) - use a
list of known file format signatures, compare them to the
first few bytes of the LOB to detect file format.

Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

<milindsj@gmail.com> wrote in message news:1143789838.448325.125190@u72g2000cwu.googlegr oups.com...

> Thanks alot,
> But we dont have interMedia.
> Is there any other way to find out what is the type present in blob
> (jpg, xls, gif, png etc)??
>
> Milind
>