Re: UTL_FILE replaces 0A by 0D 0A

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 ?

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------