it does not get saved until it encounter spool off or you exit out of sqlplus

Quoting Inder Singh <oracledba-ezmlmshield-x54927392.[Email address protected]

> 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