Re: Need help with UTL_FILE and new line char

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
flahan_at_earthlink.net

Kenny Gump <kgump_at_mylanlabs.com> wrote in message news:37453dcc.0_at_news.mountain.net...
> 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 - 07:58:54 CDT