Spool file is blank and getting error message "not spooling currently". I am executing.
sql>set feedback on
sql>spool c:\test.log
sql>@c:\testscript.sql
sql>spool off
background: - I have created a job in job scheduler (windows) which writes the data into the txt files for oracle tables. I want to create a log file of execution.
Spool file should capture the command executed and if there is any error it should be written in the spool file.