Home » SQL & PL/SQL » SQL & PL/SQL » Displaying a Word/Excel document on the Web
Displaying a Word/Excel document on the Web [message #255945] Thu, 02 August 2007 08:53 Go to next message
Duane
Messages: 581
Registered: December 2002
Senior Member
Ok, I want to store Word, Excel and PDF documents in an Oracle table and then make those documents available for people to see via the web.

My question, how do I make the documents available to the web as a hyperlink so that they can be viewed? Do I have to write the document to the Oracle server, or any available server, for the document to be available? Meaning, I must extract the document out of the table and then write it to some folder on the server with the hyperlink pointing to it?

What is the practice to accomplish this task?
Re: Displaying a Word/Excel document on the Web [message #255974 is a reply to message #255945] Thu, 02 August 2007 10:38 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
May GOOGLE help you.
Re: Displaying a Word/Excel document on the Web [message #255977 is a reply to message #255945] Thu, 02 August 2007 10:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Your question has little to do with Oracle and a LOT to do with creating a "web based" application.
The solution depends upon the architecture chosen; Java, .Net, PHP, Oracle Forms, Ruby on Rails, Oracle Express, etc.
Whole books have been written on each of the above.
It is unrealistic for you to come here & get useful answers.
Re: Displaying a Word/Excel document on the Web [message #255979 is a reply to message #255945] Thu, 02 August 2007 10:53 Go to previous messageGo to next message
Duane
Messages: 581
Registered: December 2002
Senior Member
I thought there might be a certain method in doing it, such as, htp.print or htp.p to write HTML. I was just wondering if there was a certain way to do the task, that's all.

I searched askTom and it looks like he has come up with a way to read the BLOB and then display that to the web.
Re: Displaying a Word/Excel document on the Web [message #255984 is a reply to message #255945] Thu, 02 August 2007 11:19 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You don't know, what you don't know.
Yes, it can be done, but I suspect you'll have a LONG and arduous journey before you have a functioning application.
In some/many/most cases an application server (AS) sits between the browser at the client side and the database.
The AS can be eliminated by using JSP or PSP architectures; neither of which are trivial to implement.
I suggest you take a serious look at Oracle Express.
It is GUI based & may be something you can handle.
Previous Topic: How to get count of records in a delete statement
Next Topic: all_tab_columns distinct column_name
Goto Forum:
  


Current Time: Tue Dec 03 05:05:26 CST 2024