spool creating empty file

  • From: Clay Colburn <clay.colburn@xxxxxxxxx>
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Tue, 17 Aug 2010 10:41:45 -0700

I am executing a file from within sqlplus that looks as follows:

spool output.log
set timing on
set time on
@/tmp/myfile.sql
@/tmp/myfile2.sql
spool off

The output.log file is being created, but it does not have any contents.  As
sqlplus is running myfile.sql and myfile2.sql, I can see the output that it
is generating on the screen, but the same output is not being written to the
spool file.  I know that this same method has worked before, but if someone
could point me in a direction to look for what could potentially be the
problem that would be great.

Thanks.

Other related posts: