Re: PL/SQL: More than 1023 characters without lineterminator using UTL_FILE

From: Scott Urman <surman_at_dlsun338.us.oracle.com>
Date: 1997/10/15
Message-ID: <6234u8$j9i$1_at_inet16.us.oracle.com>#1/1


In article <01bcd973$6c1652c0$9504010a_at_W00409.sd.be>, "Tom Wouters" <tom.wouters_at_sd.be> writes:
|> How can I create a file , using the UTL_FILE package, which contains more
|> than 1023 characters in a row without a lineterminator ?
|> Using UTL_FILE I always get an write error on UTL_FILE.PUT(..).
|>
|>

Currently, you can't (this has been filed as Oracle bug 458336). UTL_FILE is being enhanced to allow up to 32K characters per line for 8.0.5.



Scott Urman Oracle Corporation surman_at_us.oracle.com

Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm

"The opinions expressed here are my own, and are not necessarily that of  Oracle Corporation"
Received on Wed Oct 15 1997 - 00:00:00 CEST

Original text of this message