Re: Windows line terminations from Unix PL/SQL

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 25 Mar 2005 15:00:07 -0800
Message-ID: <1111791607.781895.122250@f14g2000cwb.googlegroups.com>

Randy Harris wrote:
> I'm writing to a file (utl_file.put_line), on an HP-UX system, but I
would
> like to have Windows line endings (13+10). How should I do it?
>
> --
> Randy Harris
> (tech at promail dot com)

IMHO, unless you have a good reason... do not write platform dependant PLSQL code. Keep the end of line as platform specific then ftp the file to *nix <--> Win* in ASCII mode.

However, if you must, then use e.g. eol_ varchar2(2) := chr(13)||chr(10); Append eol_ at the end of each string. For this, you should use utl_file.put procedure.

Regards
/Rauf Received on Fri Mar 25 2005 - 17:00:07 CST