Re: How to create a .csv file to be downloaded through the web

You can use utl_file package to produce the csv file, since DB and OAS are on two different machines then OAS will not have access to the file. The only solution I can think of is to ftp the file to the OAS machine. if OS is UNIX then you have two options create a cron job which ftp files from a directory to another and deletes the files from old directory (it is OK ).
the other option is much better and that is use external procedure call. write two shell scripts one for ftp a file to OAS and the other one to remove the file DB .
then from your PLSQL pass the required parameters and execute the shell scripts.
Tom

Ven <vkumar_at_servicelane.com> wrote in message news:38DAF0EA.D2D85938_at_servicelane.com...
> Hi guys,
> We have a corporate intranet with 3 tiers ( web browser , OAS, Oracle
Database
> Server). We are using OAS PL/Sql Cartridge to generate the HTML. Now we
want
> tocreate some reports. I can create some HTML based reports .I also need
to
> create reports that will enable the user to download the file in a comma
> delimited format from the web site, that he/she can suck into Excel for
> analysis. How do I do this, since the OAS server and the database server
are on
> different machines ?
>
> Any ideas/Suggestions ?
>
> Thanks
> Venkatesh
>
Received on Fri Mar 24 2000 - 05:55:39 CET