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 laterGeneric UNIX
Symptoms
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
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.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |