Re: UTL_FILE replaces 0A by 0D 0A

From: metzguar <urs_at_ursmetzger.de>
Date: 14 Sep 2006 02:52:09 -0700
Message-ID: <1158227529.726950.83920@e3g2000cwe.googlegroups.com>

Maxim Demenko schrieb:

> Urs Metzger schrieb:
> > Connor McDonald schrieb:
> >> Kalle Heuwes wrote:
> >>> 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
> >>
> >> any joy with put_raw ?
> > Yeah! Joy!!
> >
> > SQL> declare
> > 2 text varchar2(20) := 'ab' || chr(10) || 'cd';
> > 3 file_a utl_file.file_type;
> > 4 file_b utl_file.file_type;
> > 5 begin
> > 6 -- This won't work
> > 7 file_a := utl_file.fopen('D_TEMP', 'file_a', 'w');
> > 8 utl_file.put(file_a, text);
> > 9 utl_file.fclose(file_a);
> > 10 -- This works! Mode must be 'wb'!
> > 11 file_b := utl_file.fopen('D_TEMP', 'file_b', 'wb');
> > 12 utl_file.put_raw(file_b, utl_raw.cast_to_raw(text));
> > 13 utl_file.fclose(file_b);
> > 14 end;
> > 15 /
> >
> > file_a: 61 62 0D 0A 63 64 0D 0A
> >
> > file_b: 61 62 0A 63 64
> >
> > Urs Metzger

>

> I don't have right now a windows installation to test, but i was pretty
> sure, "WB" came only in 10g, was i wrong on it ?

>

> Best regards

>
> Maxim

You're right, Maxim, 'wb' is new in 10g.

Maybe someone out there has 9.2 on Windows and could do the test, using 'w' instead of 'wb'.

Urs Metzger Received on Thu Sep 14 2006 - 04:52:09 CDT