utl_file, long lines and Macs

Hi all,
a quick question that I hope someone on the group can help with. I'm working on a procedure that runs an Oracle 8.1.7 on Windows 2000. It uses the utl_file package to write data in a CSV-format to a text file. This file is then processed by a software on a Macintosh. The problem is the line termination characters. On Windows this is linefeed and carriage return, whereas on the Mac it's just carriage return. Of course utl_file.put_line on the Windows server writes the Windows terminating characters to the file.
Is there a way to set the character(s) that are written ? One solution we have come up with is to never call put_line (just call put) and append a linefeed where ever we need a new line. I think that this results in a huge buffer and what happens tho' if you're writing lots and lots of data out in this fashion ? (i.e. more than will fit in the buffer)

Any thoughts/experiences on this would be greatly appreciated.

Thanks,

-Richard Received on Wed Apr 24 2002 - 07:18:51 CDT