Downloadable file with PL/SQL ?

From: Wassim <net2000_at_francemel.com>
Date: Wed, 23 Jun 1999 14:02:58 GMT
Message-ID: <7kqpe9$7n2$1@nnrp1.deja.com>

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 Wed Jun 23 1999 - 09:02:58 CDT