Re: Retrieving images from PLSQL Catridge in OWS

Hi Prasad

> I am trying to retrieve images from the database table to display on the web
> page. The column is defined as long raw and successfully inserts and
> displays images from forms. I'm using PL/SQL catridge on web server 3.0.1.
> on NT.
>
> If somebody already successfully implemented this, please guide me in right
> direction.

[Quoted] Is there a specific reason to put the pages in the database? The only advantage that I have heard about is that you have transactional control of inserts, ie you can do rollbacks.

Logic dictates that pulling an image out of a database as opposed to off the [Quoted] file system will consume significantly less proccessing time, and maybe even [Quoted] io time.

Also the Web Server has the ability to cache directories, which also probably [Quoted] speeds things up.

The way you could implement your system is to have a images directory that is [Quoted] mapped by the web server. When you insert/upload/copy an image into this directory insert a record into the database with its name and web server mapped directory.

eg /images/picture1.jpg/

then in your code read the above data into a variable and use the htp.img procedure to show the image

Hope this helps

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 19 1998 - 00:00:00 CEST