« Email Address by Major/Term web app, SZRACAD | Main | SZRACAD and SZRTRAK »

July 07, 2006

Making a file downloadable from web in pl/sql

The key to making to a file downloadable versus displaying in the web browser is to add this line before any htp.prn() calls.

owa_util.mime_header('text/csv');

Depending on what your doing, you can add any mime type the browser/server supports, choose to close/not close the header, and change the character set.

procedure mime_header(ccontent_type in varchar2,
bclose_header in boolean,
ccharset in varchar2)

Posted by soukupm at July 7, 2006 03:28 PM

Comments

Post a comment

Thanks for signing in, . Now you can comment. (sign out)

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)


Remember me?