Re: UTL_FILE replaces 0A by 0D 0A

From: Kalle Heuwes <Karlheinz.Heuwes_at_web.de>
Date: 12 Sep 2006 07:00:38 -0700
Message-ID: <1158069637.980331.243590@p79g2000cwp.googlegroups.com>

Hi, Urs !

Unfortunately it also happens with UTL_FILE.put. Besides it is not only appended at the end of a row; it is even replaced in the middle of a string:

DECLARE

   lc_filename   VARCHAR2 (100)     := 'test.txt';
   lt_file       UTL_FILE.file_type;

BEGIN
   lt_file := UTL_FILE.fopen ('EXPORT', lc_filename, 'w');    UTL_FILE.put(lt_file, 'hgfxxx' || CHR(10) || 'xxxgjhg');    UTL_FILE.fclose (lt_file);
END; Kind regards
Kalle Received on Tue Sep 12 2006 - 09:00:38 CDT