Re: downloadable file with PL/SQL ?

From: Jason King <jhking_at_airmail.net>
Date: Wed, 07 Jul 1999 17:58:06 -0500
Message-ID: <D7BBB8F9E1623271.A6C3CF796A4C4832.FF9038481039EF7A_at_lp.airnews.net>


Make sure the server will send mime type application/vnd.ms-excel this same thing hosed me for a text/csv until I set the server up correctly. I'm not running oas at home so I can't tell you the exact location to change.

Wassim wrote:

> Hi,
> i'm using OWS3.0 with PL/SQL cartridge.
> In one service in my application, There's a form in which the user enter
> a date interval then hit the send button to download a result file
> generated
> by the called PL/SQL procedure, This file is an Excel file (It's a plain
> text file but
> well opened with Excel)
> I've generated the file as text/plain file to see if it is correct then
> then i change the MIME type to " application/vnd.ms-excel " :
>
> -------------
> owa_util.mime_header('application/vnd.ms-excel');
> htp.print(to_char(SYSDATE,'DD/MM/YYYY, HH24:MI'));
> htp.print(chr(13));
> ...etc.
> -------------
>
> This doesn't work ?! Browser return the following error :
> " The document contained no data.
> Try again later, or contact the server's administrator"
>
> Q:
> - How to generate a file with PL/SQL (xls, or zip, ...) ?
> - How to give a name and extension "a.xls" for example?
>
> Anyone to help?
> Thanks in advance.
>
> Wassim.
> e-mail: net2000_at_francemel.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jul 08 1999 - 00:58:06 CEST

Original text of this message