Re: PL/SQL output to desktop file via OWA

Ok, I must be woefully inept. I've used the owa_util.mim_header command described, but without sucess. Do I need to preface the command with opening a header of some sort? If I use it like this
---

   htp.htmlopen;
   htp.headopen;
    if ( disp_in = 1 ) then

        owa_util.mime_header( 'text/html' );     else

        owa_util.mime_header( 'text/save-as' );     end if;
---
in my stored procedure, I see "Content-type: text/save-as" at the top of my page.

If I drop the htp.htmlopen command, I see no result from the mime_header utility.

What am I missing?

Eric

Thomas Kyte wrote:

> 2- or you need to simply put out a mime type in your routine....
>
> For example:
>
> create procedure do_the_report( p_in_html in varchar2 default 'Y' )
> is
> begin
> if ( p_in_html = 'Y' ) then
> owa_util.mime_header( 'text/html' );
> else
> owa_util.mime_header( 'text/save-as' );
> end if;
>
> ......
> end;
Received on Thu Jul 09 1998 - 16:58:42 CDT