Re: Creating delimited output in a file

"Noah Arc" <bowed_zombie_drone.spam.begone_at_zombie.co.uk> wrote in message news:<aJPz7.46968$uM2.7969022_at_monolith.news.easynet.net>...
> Is there any way of creating delimited output in a file
> on the client's PC from the server? I can create CSVs
> using, say, Reports, but am unsure of a way of
> transferring the file from the server to the client
> (across OSes).
>
> We have Oracle Apps, so can't use anything
> client-based, such as Access or Excel; that'd be
> too easy! I'm looking for a server-based solution
> (which I'm currently doubtful that there is).
>
> Thanks for any thoughts.

You can create a delimited file on the server using sqlplus and then ftp the file if running sqlplus from the client is out.

See the cooperative FAQ entry How do I export a database to a flat file
http://www.jlcomp.demon.co.uk/faq/flatfile.html

An alternate method would be to write a stored procedure that uses utl_file to write a delimited file to the db server and then ftp this to the client. There are article on utl_file on the FAQ.

If you were using Oracle Forms as the client it has a text_io routine that could be used to create a csv file on the client.

I hope some of these suggestions are of use.

• Mark D Powell --