Generate a csv file using forms 9 and ORACLE iAS

Hi,
please advise with an example how can I generate a csv file using ORACLE developer 9 and ORACLE iAS 9. A form? a Report? The CSV file must be saved in a local machine.

Regards
Diana
dyanucaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
konektorCommented:
you can generate it using SQL+, just set proper settings

set nls_date_format = 'yyyy/mm/dd hh24:mi:ss'
set heading off
set pagesize 0
set colsep ,
set linesize 1000
spool x.lst
select ...
spool off
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
schwertnerCommented:
Oracle Forms has IO_TEXT package, but it creates files on the App. Server.

In Reports you can define the output as DELIMITEDDATA (that stands
for Excel files). Such reports could be invoked either directly from Reports
Server or from Forms.

Additioanlly Reports server can email as attachment automatically
the file.

Such files can be easily imported in Excel using the Import tab
of the Excel Sheet. The only small problem is that you have
to advise the Delimeter Character (Comma or Tab character).

0
 
dyanucaAuthor Commented:
konektor,

thanks for the solution, but unfortunately the file needs to be generated from the application.

schwertner:
I like both solutions, in fact I tried to generate the file with DELIMITED, I thought DELIMITEDDATA is just for version 10 (I am using version 9), the problem I faced with the DELIMITED is that for some reason the report is not being generated and I guess the problem is the path because I want the report to be saved on the client (local machine) due it contains restricted data. Can you please provide me some guidance on this?
Regards, Diana
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
schwertnerCommented:
I use successfully Report Builder 9.0.4.0.33

I think more important is the Reporst server:  It is 10.1.2 (OAS and also Standalone Reports Server).
0
 
schwertnerCommented:
If you invoke the report via reports Server the client can save the report
where he want.
File ------>  Safe as
0
 
Helena Markováprogrammer-analystCommented:
You can create a *.csv file from forms. You have to attach WEBUTIL.PLL to your form and then use client_text_io package. This package is like TEXT_IO package in client/server.
0
 
Helena Markováprogrammer-analystCommented:
0
 
dyanucaAuthor Commented:
Thanks a lot Henka, it looks great, I just have a question, Can I use this on forms 9i ? because on the linik says Developer 10g, and we are using the 9 one.

Regards,
Diana
0
 
Helena Markováprogrammer-analystCommented:
You can use it, because the WEBUTIL has started in forms 9i.
0
 
dyanucaAuthor Commented:
Hi Henka,

I am using iAS 9i, can I use the webutil?
0
 
Helena Markováprogrammer-analystCommented:
As I know you can.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.