SQL*Plus (MOSC)

MOSC Banner

Because "set Lin 32727 " record can not be output

edited Dec 23, 2014 10:00AM in SQL*Plus (MOSC) 6 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center