Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> GIF question. Oracle WS and images

GIF question. Oracle WS and images

From: Brad Baker <bradb_at_somerset.com.au>
Date: 1997/04/05
Message-ID: <01bc525c$7c876c50$cb566fcb@vulture>#1/1

 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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US