Re: Viewing BLOB jpgs and gifs.

You will have to retrieve your gif in chunks of about 30000 and build up your data buffer before sending your picture to IE5. I did something similar when doing CLOBS.

M

In article <811v04$12f$1_at_axis.scu.edu.au>, gmuldoon_at_scu.edu.au (Geoff Muldoon) wrote:
> jason <jason_at_seahorseNOSPAM.demon.co.uk> wrote:
> >>> PROCEDURE retr_img (id varchar2) as
> >>> Lob_field BLOB;
> >>> buffer RAW(32767);
> >>> offset BINARY_INTEGER:=1;
> >>> buffer_size NUMBER:=32767;
> >>> BEGIN
> >>> SELECT employee_image
> >>> INTO lob_field
> >>> FROM employee_table
> >>> WHERE employee_id=id;
> while offset < length loop
> instead of
> >>> LOOP
> >>> DBMS_LOB.READ(lob_field,buffer_size,offset,buffer);
> >>> htp.print(UTL_RAW.CAST_TO_VARCHAR2(buffer));
> >>> offset:=offset+buffer_size;
> >>> END LOOP;
> >>>
> >>> EXCEPTION
> >>> WHEN NO_DATA_FOUND THEN
> >>> null;
> >>> END retr_img;

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!