Re: urgent please help: utl_file.put_line

[Quoted] Have you tried dropping the length to just less than 1000 bytes (it could [Quoted] be that, since it's a put_line, Oracle is whapping a CR or LF onto the end [Quoted] and taking you over the 1000 byte limit. Jim

susana73_at_hotmail.com wrote in article <742685$hrc$1_at_nnrp1.dejanews.com>...
> Hi,
>
> I am trying to dump out tables into ascii using utl_file package. I know
 the
> put limit is 1k, so i tried to split strings that have length > 1k.
>
> ...
> len := length(t1_rec.f1); -- length of f1 is about 1800 chars
> utl_file.put_line(f_handle, SUBSTRB(t1_rec.f1, 1, 1000));
Received on Wed Dec 02 1998 - 00:00:00 CET