OraFAQ Forum: SQL & PL/SQL » Max line of spool ?

Home » SQL & PL/SQL » SQL & PL/SQL » Max line of spool ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Max line of spool ? [message #135337]

Wed, 31 August 2005 02:36

vcftse
Messages: 3
Registered: August 2005

Junior Member

hi all,

im extracting data to a spool file, so what the max line is ?

set pages 999
set lines ????
set colsep ','
set trimspool on
set head off

Many thanks if any help !!

Report message to a moderator

Re: Max line of spool ? [message #135342 is a reply to message #135337]

Wed, 31 August 2005 03:31

Maaher
Messages: 7065
Registered: December 2001

Senior Member

From the manual

You can define LINESIZE as a value from 1 to a maximum that is system dependent. Refer to the Oracle installation and user's manual(s) provided for your operating system.

Or you could try it yourself. Did you? Try to set it to a high value and see.

On windows ( SQL*Plus Release 8.0.6.0.0 )

Quote:

SQL> set lines 330000
linesize option 330000 out of range (1 through 32767)

On Soraris ( SQL*Plus Release 9.2.0.6.0 )

Quote:

SQL> set lines 33000
SP2-0267: linesize option 33000 out of range (1 through 32767)

MHE

Report message to a moderator

Re: Max line of spool ? [message #135398 is a reply to message #135337]

Wed, 31 August 2005 07:44

linlasj
Messages: 98
Registered: August 2005
Location: LinkÃ¶ping

Member

If I remember correctly I set this to 0 (!) and thus it will preserve whatever comes out of the SQL. But that seems to be impossible with this version. Sorry.

[Updated on: Wed, 31 August 2005 07:45]

Report message to a moderator

Previous Topic:	Problem in designing the procedure.
Next Topic:	set command???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 11 00:20:24 CDT 2025