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