OraFAQ Forum: Forms » How to get BLOB file extension

Home » Developer & Programmer » Forms » How to get BLOB file extension (forms 10G)

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

How to get BLOB file extension [message #462567]

Fri, 25 June 2010 00:55

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

There are different types of files loaded in databse BLOB type column, .doc, .xls, .pdf or even .xlsx and .docx. Now, I need to download these file and open it. The problem is how can I determine what file extension these files have.

Help needed from you guys.

Report message to a moderator

Re: How to get BLOB file extension [message #462568 is a reply to message #462567]

Fri, 25 June 2010 00:56

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Extensions are meaningless for Oracle.
Store in another column the associated application that you have to use to open it.

Regards
Michel

Report message to a moderator

Re: How to get BLOB file extension [message #462570 is a reply to message #462568]

Fri, 25 June 2010 00:58

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Thanks for your reply.

What do you mean by store associated application?

Report message to a moderator

Re: How to get BLOB file extension [message #462577 is a reply to message #462570]

Fri, 25 June 2010 01:32

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you want the extension this is because you want to know if it an Excel, PDF, Word... document, isn't it?
So store this name of the application in a column or store the extension, as you want.

Oracle can't know the extension, so you have to tell it.

Regards
Michel

[Updated on: Fri, 25 June 2010 01:33]

Report message to a moderator

Re: How to get BLOB file extension [message #462578 is a reply to message #462577]

Fri, 25 June 2010 01:35

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Okay, thanks Michel.

I thought there was a way. But since ther's not, I'll have to do it that way.

Report message to a moderator

Re: How to get BLOB file extension [message #462579 is a reply to message #462578]

Fri, 25 June 2010 01:59

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

As some programs (like mail filters) are able to (sometimes) determine which type of file it is analyzing the binary I think it is (sometimes) possible but I bet it is a non trivial code.
(Maybe you could find something searching on the web.)

Regards
Michel

Report message to a moderator