Re: formatting output with SQL*Plus

On 09.12.2004 08:04 Frank Piron wrote:

> 1)
> Write a stored proc which spools the text file using
> the utl_file package. You have full control over the
> formatting and you have a chance to understand it if
> you look at it 2 years later.
>
> 2)
> Call the stored proc with SQL*Plus from your batch.
>

I have never used the utl_file package, but to my knowledge this will create the file on the server, correct?
As I have no access to the Oracle server (other then through SQL) how would I get the file from the Oracle server to the server where the batch file is running?

Cheers
Thomas Received on Thu Dec 09 2004 - 02:17:55 CST