SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to know the extension of the file stored in BLOB

569980Mar 30 2007 — edited Mar 30 2007

Hi Frens

I've a BLOB column in which signatures are stored.Now i am extracting the signatures which are stored in the server.The extension of the file is .bmp as I'm appending it while extracting the file.Is there a way to know what is the file format or extension of the file which is stored in the BLOB coz I facing some problems with it.I just want to export the file with the same extension with which it was inserted in like .gif or .jpg.
If u people know any resolution to this problem,please lemme know...It will be a great help

With Regards
Mohit

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 27 2007

Added on Mar 30 2007

3 comments

2,573 views