Home » SQL & PL/SQL » Client Tools » "Not spooling currently" Error message (10.2.0.3.0)
"Not spooling currently" Error message [message #390116] Thu, 05 March 2009 01:02 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

I am getting the following message while executing ".sql" file.
not spooling currently
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Can any one please let me know the reason for getting this message and give me the solution for this.

Thank you
Re: "Not spooling currently" Error message [message #390117 is a reply to message #390116] Thu, 05 March 2009 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have a "spool off" without a previous "spool".

Regards
Michel
Re: "Not spooling currently" Error message [message #390120 is a reply to message #390116] Thu, 05 March 2009 01:11 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
user71408 wrote on Thu, 05 March 2009 08:02
Can any one please let me know the reason for getting this message and give me the solution for this.

I think the error message is self-descriptive.
SQL> spool a.txt
SQL> spool off
SQL> spool off
not spooling currently
SQL> disc
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> 

You see the command which issued that message. Find it in the script (if there are more, take the one without matching SPOOL <filename>) and remove it.
Re: "Not spooling currently" Error message [message #390122 is a reply to message #390117] Thu, 05 March 2009 01:23 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Michel,

Now I gave
SPOOL ON
SQL Query
Spool Off

now I am getting
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
message.

one more thing is I want to spool this data to abcd_<Sysdate>.txt. Please tell me how to do that.

Thank you,

[Updated on: Thu, 05 March 2009 01:25]

Report message to a moderator

Re: "Not spooling currently" Error message [message #390127 is a reply to message #390122] Thu, 05 March 2009 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
one more thing is I want to spool this data to abcd_<Sysdate>.txt. Please tell me how to do that.


This is a FAQ. ./fa/456/0/

Regards
Michel

[Updated on: Thu, 05 March 2009 01:38]

Report message to a moderator

Re: "Not spooling currently" Error message [message #390128 is a reply to message #390122] Thu, 05 March 2009 01:39 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SQL*Plus User's Guide and Reference book contains description of all SQL*Plus commands, which includes SPOOL. Read it and learn how to use it.
Previous Topic: Oracle datatype to store ONLY DATE without time
Next Topic: iSql*Plus
Goto Forum:
  


Current Time: Fri Dec 09 07:39:58 CST 2016

Total time taken to generate the page: 0.07701 seconds