Oracle Portal...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle Portal...

  1. #1
    Join Date
    May 2003
    Posts
    16

    Oracle Portal...

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width