Good monring Tom,

I have used some of your previous answers, and hence I am able to
populate a blob column. I know it is populated because when I put character data in it, my web page shows the length and the characters.
However, when I put a jpg or gif in it, the length is shown, but the gif or jpg show up as if it was being edited by something like word pad. The image is returned as uprintable characters. This happens on both netscape 4 and ie 4.

Here is the code I am using to display the image:

procedure gif( p_id in web_picts.pic_id%type )
is
l_lob blob;
buffer raw(32000);
buffer_size integer := 32000;
offset integer := 1;
length number(8);
begin
owa_util.mime_header('image/gif');
select picture into l_lob
from web_picts
where pic_id = p_id;
length := dbms_lob.getlength(l_lob);
while offset < length loop
dbms_lob.read(l_lob, buffer_size, offset, buffer);
htp.p('Picture Length ' || length);
--htp.p(l_lob);
htp.prn(utl_raw.cast_to_varchar2(buffer));
offset := offset + buffer_size;
end loop;
exception
when others then
htp.p(sqlerrm);
end;

And here is the code that calls the above:

Procedure home

is

theImage blob;
Begin
htp.p ('test...just to be sure a page is showing');
image_get.gif(1);

Exception
When others Then
null ;
End;

The above is a condensed example dealing with only getting the blob.

This is what the web page shows for the image:

test...just to be sure a page is showing Content-type: image/gif Picture Length 17050
ÿØÿà‘¡±B#$RÁb34r‚ÑC%’Sðáñcs5¢²ƒ&D“TdE£t6ÒUâeò³„ÃÓuãóF'”¤…´•ÄÔäô¥µÅÕåõVfv†–¦¶ÆÖæö7GWgw‡—§·Ç×ç÷UËk7HqLyÙ»Wåî)32ÀdsÒLH7í,òÔn–Ú}²>¥sqÆùÝRS§ŽÙ¸q9q9ù̦w&þO
©} B’„'¡)zÓ‡hÁ©+ætŽ.vekbö”ùÈó
7Ö®u~K–µkU[n¿?ó‰µî:«1N’*²*u”P„P„P„P„P„P„P„P…«?€‰2R§
'§¤Ô3I¤,ÐñXùù%ˆøñåGOç+úë€Üww=Ä4égÄäÎÖÃV%6Àù`ÚÒ!õ¬žzx~ÚK¬”Ëíãnem1ò×
?5´Ué*?º±Ä³H‡búvîʎt8üD*ײÝ@6õª³¡Ë4C±ª0Û5õ†#®+î(!§¥pô$šÁ


This happens on both the server machine and my work machine, so I think it is a setting of some kind...something simple.

At any rate, many thanks in advance for any assistance you may offer.

Les Davidner