Hi all,

I've got a set of scripts that I run in Sql*Plus, running in the Classic
environment on Mac OSX. The scripts use the spool feature to export
large volumes of data from an Oracle database table to a file, and the
data is subsequently being imported into OpenBase using the (very fast)
ImportFile stored procedure.

The only flaw is, the files created by Sql*Plus have a Mac line feed
(hex 0D) and the OpenBase stored procedure only works with a UNIX line
feed (hex 0A). I have tried a number of different SET parameters in
Sql*Plus, and I've also tried a number of different NLS_LANG options,
but I can't get Sql*Plus to export with UNIX line feeds.

I can change the line feed in BBEdit or TextWrangler, but this involves
opening the file, which doesn't work well when the file gets VERY big.

Any ideas on how to export with UNIX line feeds?

Any better way to change the line feeds on an existing document?

Thanks,

Jim