Programming/
 Tools

      Oracle
      JavaScript
      C#

 Fun Stuff
      Music
      Martial Arts
      Robotech

 Other
      Main


DISCLAIMER
This disclaimer is intended to cover all software/freeware, and other various files which are downloadable through or from this site.
Joe Garrepy, isp, and web host can not be held responsible for any software downloaded from this site. All freeware is downloaded at your own risk. Software which is listed on this site is assumed to work properly, but may or may not have different effects on different computer systems. The same rules apply to these programs. Joe Garrepy assumes no responsibility for those unusual occurrences where software has adverse effects on users computer. Joe Garrepy does not warrant these programs/files, and as such, can offer no guidelines in which to use them. All freeware/software/files, trademarks, service marks, and copyrights are acknowledged as belonging to their owners. Any of these which the owner wishes to be removed will be done so immediately. By downloading any software or viewing pages in which software can be downloaded, you agree to be bound to this agreement.

JoeGarrepy.com Oracle Store and Display Image on Web Stored as BLOB using Oracle Web Application Server

The following code is for importing images from a directory on the host machine Oracle resides on into the database and then displaying them on the web with the Oracle Web Application Server. One of the cool things about Oracle is the built in Web Application Server which uses packages like SYS.HTP to create web pages using PL/SQL. The next logical step after creating a simple web page is using it to display or download content files stored in the database. Though this example is for displaying images it could be used for any type of file that is stored as a BLOB.

SQL Script
When you display your page it should look like the following...
Diplay Image from BLOB in Database
Display Image

Click to Display Full Image

Click to Display Full Image


If you find any bugs or want to contact me I can be reached @ doughjoe77@hotmail.com.