Re: Need help with UTL_FILE and new line char

From: Patrick Flahan <>
Date: Fri, 21 May 1999 08:58:54 -0400
Message-ID: <7i3ldf$8kd$>

If you use the utl_file.put_line procedure it should put add line terminator for you. You could also use the utl_file.new_line procedure which inserts new line characters. Or you could concatenate a chr(10), the ascii equivalent of a new line. I am not sure using a '\n' will work in pl/sql.

Hope this helps,
Patrick Flahan

Kenny Gump <> wrote in message
> When you write the line out to the file use \n at the end to for new line.
> Kenny Gump
> OCP 7.3 DBA
> Ryan wrote in message ...
> >I have create a PL/SQL script that uses UTL_FILE to output strings to a
> >file. It works fine except I cannot figure out how to add a newline
> >character after each a line so a new line is inserted into the file.
> >Currently all strings are concatenated into one continuous line.
> >
> >Any help would be appreciated.
> >Please remove [NOSPAM] from email to reply.
> >
> >Ryan
> >
> >
Received on Fri May 21 1999 - 14:58:54 CEST

Original text of this message