Re: UTL_FILE replaces 0A by 0D 0A

From: metzguar <urs_at_ursmetzger.de>
Date: 12 Sep 2006 02:23:03 -0700
Message-ID: <1158052983.484564.236140@p79g2000cwp.googlegroups.com>

Kalle Heuwes schrieb:

> Hi !
>
> This problem arises on Oracle 9.2.0.6.0 with Microsoft Windows.
>
> I have to write hex values to a text file and do it by
> UTL_FILE.put_line(pin_filehandle, pic_text);
>
> On Unix-servers everything is OK. On Windows-Servers a hex value of
> "A6 0A 32" is written to file as
> "A6 0D 0A 32". Thus the file is destroyed for the application that has
> to read the file.
>

Kalle,

this behaviour is expected an documented in the Supplied PL/SQL Packages and Types Reference for Oracle 9i: "PUT_LINE terminates the line with the platform-specific line terminator
character or characters."

Try using UTL_FILE.put instead.

Urs Received on Tue Sep 12 2006 - 04:23:03 CDT