Re: GIF image data and Oracle

Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote in article <33447556.1D1_at_exesolutions.com>...
> > We are developing a dynamic Web application using Oracle and we are
> > writing out Web output using PL/SQL. We intend to store GIF images in
> > the database as LONG RAW.
 

> > My question is "How do I get image data into and out of Oracle?"
> > We are running under Windows NT. What Oracle tools (and statements)
> > can I use to insert a GIF file into a column?
>
> The only way I know, other than with a tool like Paradox For Windows, is
> to write ProC.
>
> Daniel A. Morgan
>

Okay I have a handle on how we are going to get the images in the database.  I used MS Access to intsert a GIF file for testing.

My next question is how can I return these images in relation to Web browser request.

I had planned to write a PL/SQL procedure that would return an image given an image id

	procedure image(img_id in varchar2)
	begin
		select ....
		htp.prn(row.image_blob);
	end

And In my html write something like

        <img src="\us\owa\image?img_id=12345" ...>

However with this approach I dont get any image coming back to the browser.  Can I use the htp.prn() function to return pure image data?

Note I wrote out the mime/header as "image/gif." before sending the reply. Received on Sat Apr 05 1997 - 00:00:00 CST