Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> GIF question. 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 CST