Hi

create or replace procedure download(p_file_id files.id%type)
as
l_lob files.content%type; l_mime mimetypes.name%type;
begin
select f.content, m.name
into l_lob, l_mime
from files f, mimetypes m
where f.id = p_file_id
and f.mimetype_id = m.id;
owa_util.mime_header(l_mime, false);
owa_util.http_header_close;
wpg_docload.download_file(l_lob);
end;

call this proceedure in your webbrowser.

regards
Hrishy