Yes they were - thanks.
--
Noah Arc
Remove ".spam.begone"
Mark D Powell <mark.powell_at_eds.com> wrote in message
news:178d2795.0110191004.3e816e7a_at_posting.google.com...
> "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 --
Received on Thu Oct 25 2001 - 01:07:44 CDT
