Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Downloadable files with PL/SQL ?
You will have to add the MIME type to the list of MIME types allowed to be
sent by the listener.
Do it in the listener configuration section under MIME types. Then, restart the listener.
Wassim <net2000_at_francemel.com> wrote in message
news:7kqp7s$7jq$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 Thu Jun 24 1999 - 02:56:07 CDT