UTL_FILE Extra FormFeed in Windows??

From: <k.sriramkumar_at_iflexsolutions.com>
Date: Thu, 27 May 2004 19:30:22 +0530
Message-ID: <10898BE7CA96D611988B000802255AAF0675C6ED@fmgrt.rt.i-flex.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu May 27 2004 - 08:54:01 CDT