Oracle Portal...

[rameshbabumande]

Dear Members,

I inserted a document into Oracle database field BLOB , and I am retrieving using pl/sql web portal .

I am using owa.util.mime_header('application/msword').It is giving me a garbage data onto the browser . If I am inserting a text file and viewing it in a brower with 'text/html' it is displaying well .Can any one tell me where the problem is all about .


Ramesh.M

[hrishy]

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