UTL_FILE Extra FormFeed in Windows??
- From: <k.sriramkumar@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 May 2004 19:30:22 +0530
Hi Gurus,
I have the following code, when I run this code in a DB on unix, it runs
perfectly but when I run this code in DB on windows, it adds a additional form
feed character(chr(12)) at the end.
CREATE OR REPLACE PROCEDURE edi_tst IS
out_file UTL_FILE.file_type;
out_line VARCHAR2 (200);
begin
out_file := UTL_FILE.fopen ('c:\', 'tst.txt', 'w',32000);
UTL_FILE.put (out_file, 'TEST');
utl_file.new_line(out_file, 1);
UTL_FILE.put(out_file, 'TEST Line 2');
UTL_FILE.put(out_file, 'TEST');
UTL_FILE.fclose(out_file);
end;
Output of Octal Dump for a file created in Windows
/tmp> od -bc tst.txt
0000000 T E S T \n T E S T L i n e 2
124 105 123 124 012 124 105 123 124 040 114 151 156 145 040 062
0000020 T E S T \n
124 105 123 124 012
Any clues how to avoid the extra form feed character??
Best Regards
Sriram Kumar
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
