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 -> Re: Viewing BLOB jpgs and gifs.

Re: Viewing BLOB jpgs and gifs.

From: mgumbs <mgumbsNOmgSPAM_at_hotmail.com.invalid>
Date: Fri, 19 Nov 1999 05:43:37 -0800
Message-ID: <2750ac20.7da6cee3@usw-ex0102-010.remarq.com>


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;

Received on Fri Nov 19 1999 - 07:43:37 CST

Original text of this message

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