Re: Spooling large records

In my opinion it is simpler to use sqlplus to unload data in flat files.

My sqlplus version can handle lines up to 32767 chars...

ViDM

Jeremy Ovenden wrote:
>
> If my understanding is correct, in sqlplus you cannot set linesize param to
> more than 255 chars and that utl_file in pl/sql is restricted to a line size
> of 255 chars too.
>
> I need to create a flat file (solaris 2.6) which contains data from the
> oracle (8.0.6) database but the record size created will likely be circa
> 1000 characters. What is the best way of creating this?
>
> Jeremy Ovenden
Received on Mon Nov 08 1999 - 09:57:34 CST