SPOOL command creates UNIX file fmt on PC

[Ron E]

We have 2 people with 11.0.4.1788 (64 bit). When they SPOOL to a PC file from a command script, the results come out as UNIX format (0D only between lines). Older versions create normal PC files with SPOOL running the same code. We don't see any obvious settings to change this. Is there a preference to set, or some other way around it?

We don't have any 32 bit versions installed. But if it's a bug, do you know whether the 32 bit version is also that way? We noticed a similar issue listed in a 'New Features' list, that seemed specific to the 64 bit.

---------
(4/28/16) Addendum: One of the users had the closest previous version that we had installed (9.0.2.1621), and the SPOOL command worked properly there. So whatever changed, it was between those 2 versions. Sorry it was so far back, but it was as close as we had.

If it's any consolation, he first tried it on the latest version of TOAD, which some of our DBAs use, and it had a different problem, but still didn't work properly there either.

Thanks,

Ron E.

 

[Ron E]

After another look, I stated the issue incorrectly. The output files from a SPOOL command have a 0D at the front of the first and last lines of Spooled text, but there are no line feeds (or anything else obvious) to be found at the end of each line. That's why it was wrapping, rather than that it missed the CR characters. Oddly, the text looked normal as it scrolled past in the COMMAND window.

The Oracle command is
spool filename;

set colsep '|'
set pagesize 1
set numwidth 25
select...

spool off

Thanks,

Ron