Storing MS Word, MS Excel, PDF, etc in DB and retrieving through WebForms
Hi,
We have an application that requires storing MS Word, MS Excel,
PDF and HTML docs. We're planning on storing these documents in
a table as BLOB's with a column in the table that would indicate
the MIME type for the document. We need to be able to retrieve
these documents using the WebForms application we created. The
user would prefer to view a Word document in MS Word, an Excel
document in MS Excel, and so on. As of now there is no
requirement for searching within these documents, all we have to
do is retrieve them from the db and display them to the client.
Keep in mind this is a web based app, developed with Forms6i, we
would like to give the user the ability to press a button and
have the document displayed in the appropriate program.
I've searched for examples for this type of situation and have
been unsuccessful. But after reading about Oracle Text it
sounds like this could be what I'm looking for, minus the search
capability that is. Am I looking in the right place? Is it
possible to accomplish the requirements described above using
Oracle Text? If not where should I be looking.
Any help, info or even better sample code on this would be
greatly appreciated.
Thanks in advance,
Jeff Butler