procedure custom_image_display (p_cf_id in cust_foto.cf_id%type)
as
  l_mime varchar2( 255 );
  l_length number;
  l_file_name varchar2( 255 );
  lob_loc BLOB;
begin
 
  select cf_mime_type, cf_foto, cf_name, dbms_lob.getlength(cf_foto)
    into l_mime, lob_loc, l_file_name, l_length
    from cust_foto where cf_id = p_cf_id;
 
   -- Set up HTTP header
   -- Use an NVL around the mime type and  if it is a null, set it to
   -- application/octect - which may launch a download window from windows
   owa_util.mime_header(nvl(l_mime,'application/octet'), FALSE );
 
   -- Set the size so the browser knows how much to download htp.p('Content-length: ' || l_length);
   -- The filename will be used by the browser if the users does a "Save as" htp.p('Content-Disposition: filename="' || l_file_name || '"');
   -- Close the headers
   owa_util.http_header_close;
 
   -- Download the BLOB
   wpg_docload.download_file( Lob_loc );
end;

<br /><br /><br /><div style="text-align:center;">
<img id="FOTO_IMG" src="htmldb_util.get_blob_file_src('FOTO_IMG','&P8_KCF_ID.')" height="200px" />
</div>