GIF images, Oracle WS and images

 I have used MS Access to insert GIF files into a long raw column in an Oracle table. (because Oracle has no good client tools to do this!)

My 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.

Is there another way to do this? (I know I could put the images on the file system,
and store the location however I want to have all my data in Oracle.) Received on Sat Apr 05 1997 - 00:00:00 CEST