downloadable file with PL/SQL ?
From: Wassim <net2000_at_francemel.com>
Date: Wed, 23 Jun 1999 14:08:07 GMT
Message-ID: <7kqpnt$7qt$1_at_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.
Date: Wed, 23 Jun 1999 14:08:07 GMT
Message-ID: <7kqpnt$7qt$1_at_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 - 16:08:07 CEST