upload/download
Download from database
htp.init; — The mime header indicates what the type of the file is (browser will react on that) owa_util.mime_header(r_bfe.filetype, false); — use Content-Disposition: attachment to open a dialog box or inline to open in place htp.p(‘Content-disposition: attachment; filename=’||r_bfe.filename); htp.p(‘Content-length:’||dbms_lob.getlength(r_bfe.content) ); owa_util.http_header_close; — Write the BLOB to a browser session ( Read more…