Re: urgent please help: utl_file.put_line
From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: 1998/12/02
Message-ID: <743s4b$sq3$1_at_newton.a2000.nl>#1/1
Date: 1998/12/02
Message-ID: <743s4b$sq3$1_at_newton.a2000.nl>#1/1
Jim wrote
>Have you tried dropping the length to just less than 1000 bytes (it
could
>be that, since it's a put_line, Oracle is whapping a CR or LF onto
the end
>and taking you over the 1000 byte limit.
Could be, but I doubt it as the limit is 1023 bytes, not 1000. So, using substr( ..., 1000) gives Oracle plenty of characters to add the CR.
Arjan. Received on Wed Dec 02 1998 - 00:00:00 CET