Re: Downloadable files with PL/SQL ?

I am not sure about version 3, but version 4.07 docs. include a sample app. for file uploads and downloads which is very detailed..

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 Jun 24 1999 - 20:18:32 CDT