Re: Sql PLus - extra linefeed

Hello Ken

You need to do binary edit on the file (use textpad) and see what exactly is in the blank line.
If it is only 0D0A you can use a batch utility like change.exe to change all 0D0A0D0A to 0D0A and this will remove the extra line.

Adar Yechiel
Rechovot, Israel

Ken Naim wrote:

>I am having a issue with the spooling of a query to file where sql plus is
>inserting an extra linefeed and I cannot determine the cause. The file will
>be imported into a 3rd party app that I do not have any control over. I
>might be missing the obvious as I have working on it all afternoon so I
>appreciate any assistance. I am running on oracle 10gR1 on windows. Sql plus
>is running on the server.
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l