Re: OWS: how to retrive image from db?

Guess it's not recognized as image... You'll need it as MIME type image, otherwise it will be text.
However, I don't have an elegant solution for this. I suspect the call should be:
<img src="/servicename/owa/imageretriver.GIF"> in order to have it recognized as gif image. On the other hand, that might just be the solution; create a packaged procedure GIF inside a package imageretriever. You have the code... Let me know - find this an intreging one

klimsamgin wrote:

> Hi!
>
> I've got a web interface to the database
> (OWS on Solaris 2.5, Oracle 7.3) and
> I can see text strings from tables through a browser.
> But in some tables I store gif images in LONG RAW format.
> Is there a way to retrive pictures from database and
> see them in a browser? (A simple one is to store images on
> disk and call them through <img...> tag, but
> the images are already in database.)
>
> When I build html page, I use <img src="..."> tag (htp.img)
> to call the picture, where src="/servicename/owa/imageretriver".
>
> procedure imageretriver is
>
> cursor retriveimg is
> select img
> from image
> where n=1;
>
> imagebuff image.img%type;
>
> begin
> open retriveimg;
>
> fetch retriveimg into imagebuff;
>
> close retriveimg;
>
> htp.prn(imagebuff);
> end;
>
> end;
>
> And it works, but in stead of image I've got
> it's hex code (you know, header GIF89 is 47494638396190...).
>
> Thanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV

Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046