Re: UTL_FILE output line length.

From: <steve_young_at_my-dejanews.com>
Date: Wed, 23 Dec 1998 02:08:21 GMT
Message-ID: <75pjak$dtr$1@nnrp1.dejanews.com>

You can simply use 'spool' in sqlplus to copy out what u select(in a query) into a file. However, limit of string concatenation is 2k.

Steve

In article <19981222120911.00847.00000187_at_ng-fi1.aol.com>, hooperce_at_aol.com (Hooperce) wrote:
> Is there any way to have an output line from UTL_FILE go over 1k in length?
> Thanks in advance...
> Chuck Hooper
> Pro Relational Systems
> Charles_Hooper_at_ProRelSys.Com
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 22 1998 - 20:08:21 CST