Because "set Lin 32727 " record can not be output
my customer use shell script(Exesql.sh) to start sqlplus,then execute sql file by sqlplus.
in the sql file(select.sql),if set lin 32727 is setted, only one record is output,but if "set lin 30000" is setted,300 row records are output.
Reproduce
$./Exesql.sh -f sql_script_file_MAR_PRD_20141201.sql
sql_script_file_MAR_PRD_20141201.sql
----------------------
/* Script Parameters */
--,USERNAME,MARDB,
--,PASSWORD,,
--,HOSTNAME,,
--,DBNAME,prd27n,
--,SERVICENAME,s_mardb,
--,NLS_LANG,,
--,STOP_FLAG,1,
/* Sql Scripts */
@select.sql
----------------------
select.sql
--------------
SET ECHO ON
SET LIN 32767
SET LONG 32000
SET LONGCHUNKSIZE 32000
SET PAGES 0