Skip to Main Content

Database Software

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!

Storing MS Word, MS Excel, PDF, etc in DB and retrieving through WebForms

114475Dec 5 2001
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2002
Added on Dec 5 2001
2 comments
256 views