SQL & PL/SQL

Hello,

I am trying to spool a SQL statement to generate a CSV file in Unix server. Total record count expected in the file is 674,378 where as the spooled output file contains only 637256 records. When I do a count on the sql statement it gives the expected count. I could find where exactly the records are missing. Can somebody help me with the issue if I am missing any parameters?

Script
**********************
set termout off
set arraysize 200
set echo off
set verify off
set trimspool on
set headsep off
set pagesize 0
set pages 0
set feed off
set linesize 3000


spool &1.GL_Extract_&2..csv

WHENEVER SQLERROR EXIT FAILURE ROLLBACK;

<<<<SQL Statement>>>>

spool off

**********************************************

Thanks,
Sriram

Edited by: 959903 on May 21, 2013 6:29 AM