"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
news:1111791607.781895.122250_at_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
Thanks. I very much understand the value of platform independance. In this
case however, the file is being "fed" to another system for automated
processing and I haven't (so far at least) figured out how to ftp from
PL/SQL.
Received on Fri Mar 25 2005 - 18:16:46 CST
