Re: How to create a .csv file to be downloaded through the web
From: Vincenzo Scervo <scervo_at_praxis.it>
Date: Mon, 27 Mar 2000 09:31:57 -0800
Message-ID: <8bn6fe$3cl$1_at_fe1.cs.interbusiness.it>
Date: Mon, 27 Mar 2000 09:31:57 -0800
Message-ID: <8bn6fe$3cl$1_at_fe1.cs.interbusiness.it>
Hello,
just use htp.print command to produce you csv file and before the first
htp.print instruction tell the browser the mime type of the file you are
sending is a csv file. I did something like that to open a rtf file on a
client. I used the owa_util package to define the mime type of the file.
owa_util.mime_header('application/rtf', TRUE);
Remember to define the mime type on the OAS as well. bye.
-- VIncenzo Scervo ------------------------------------------ Praxis Calcolo S.p.A. Via Cavour 261 00184 Roma Tel.: 06 4871469 Fax.: 06 4746753 ------------------------------------------ Non si vede bene che con il cuore, l'essenziale è invisibile agli occhi Ven <vkumar_at_servicelane.com> wrote in message news:38DAF0EA.D2D85938_at_servicelane.com...Received on Mon Mar 27 2000 - 19:31:57 CEST
> 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
>