Thanks, Connor !
Andrey -, December 18, 2015 - 1:04 pm UTC
It didn't work ( May be because I have Windows? But what can i do if my platform is Windows?
December 19, 2015 - 4:20 am UTC
OK - do it in raw mode. I just tried on Windows
declare
file_type utl_file.file_type;
begin
file_type:=utl_file.fopen('TEMP','DATA.RAW','wb');
for i in 1 .. 10 loop
utl_file.put_raw(file_type,utl_raw.cast_to_raw('Hello'||chr(10)));
end loop;
utl_file.fclose(file_type);
end;
/
btw, I should have said before - DONT use
open cursor
loop
fetch
exit when not found
end loop;
Way too slow...change it to
for i in cursor loop
end loop;
Much faster.
nejia, April 26, 2021 - 9:24 am UTC
thank you I changed CHR(13) by CHR (10) and it worked
April 27, 2021 - 6:10 am UTC
glad it worked out