RE: spool creating empty file
- From: <rajendra.pande@xxxxxxx>
- To: <clay.colburn@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 17 Aug 2010 13:45:16 -0400
Check the files that you are running. They may have their own spool
commands
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Clay Colburn
Sent: Tuesday, August 17, 2010 1:42 PM
To: Oracle-L@xxxxxxxxxxxxx
Subject: spool creating empty file
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.
Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
for important disclosures and information about our e-mail
policies. For your protection, please do not transmit orders
or instructions by e-mail or include account numbers, Social
Security numbers, credit card numbers, passwords, or other
personal information.
Other related posts:
