Try set pages0

Inder Singh wrote:

>I have the following sql which spools to some file. When I check the
>txt file first line is emplty. Is there any sql setting, with which it
>should not happen.
>
>set serveroutput on size 999999
>
>set linesize 50
>
>set head off;
>
>set feed off;
>
>set title off;
>
>set verify off;
>
>spool /tmp/pcsd_order_ack.txt
>
>select oeh.order_number
>
>from oe_order_headers_all oeh,
>
>ra_salesreps_all rsa
>
>where nvl(oeh.attribute3,'A') = 'N'
>
>and oeh.order_type_id <>1085
>
>and oeh.cancelled_flag <> 'Y'
>
>and oeh.org_id=106
>
>and rsa.salesrep_id=oeh.salesrep_id
>
>and rsa.name like '%PCSD%'
>
>;
>
>
>
>Regards,
>
>Inder
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>

Oracle LazyDBA home page