Download file with wpg_docload

download.sql

declare
    l_file files%rowtype;
begin

    select *
    into l_file
    from files
    where id = 261;
    
    owa_util.mime_header(l_file.mime_type);
    htp.p('Content-length: ' || dbms_lob.getlength(l_file.file_contents));
    owa_util.http_header_close;
    
    wpg_docload.download_file(l_file.file_contents);

end;