SP2-0308 using SPOOL OFF in SQL*Plus (Doc ID 123895.1)

Last updated on DECEMBER 11, 2019

Applies to:

SQL*Plus - Version 8.1.7.0 and later
Generic UNIX

You run scripts which spool output to a file. Your scripts now error with SP2-0308 when "spool off" is issued.

SQL> spool script.out
SQL> spool off
SP2-0308: cannot close spool file
SQL> spool off
not spooling currently

SP2-0308 has been reported when the spooled file is over 2 gig.
However, your spooled file is quite small.

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.