RE: spool creating empty file
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "clay.colburn@xxxxxxxxx" <clay.colburn@xxxxxxxxx>, Howard Latham <howard.latham@xxxxxxxxx>
- Date: Tue, 17 Aug 2010 19:04:53 -0400
http://download.oracle.com/docs/cd/B13789_01/server.101/b12170/ch3.htm#i1133106
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Clay Colburn
Sent: Tuesday, August 17, 2010 6:51 PM
To: Howard Latham
Cc: rajendra.pande@xxxxxxx; Oracle-L@xxxxxxxxxxxxx; andy@xxxxxxxxxxxxxxx
Subject: Re: spool creating empty file
I'm not familiar with login.sql, can you elaborate?
On Tue, Aug 17, 2010 at 1:30 PM, Howard Latham
<howard.latham@xxxxxxxxx<mailto:howard.latham@xxxxxxxxx>> wrote:
check your login.sql
On 17 August 2010 19:10, Clay Colburn
<clay.colburn@xxxxxxxxx<mailto:clay.colburn@xxxxxxxxx>> wrote:
I went one step further and just spooled select sysdate from dual to a new file
and the file was created in the same directory as output.log and has output
included in it. Consider this thread closed unless I can come up with
something more informative to report.
thanks for the assistance!
On Tue, Aug 17, 2010 at 11:04 AM,
<rajendra.pande@xxxxxxx<mailto:rajendra.pande@xxxxxxx>> wrote:
Any other set commands in the sql file
Cant see why they may interfere with spool
Can you comment out the 2 files and just run select sysdate from dual and see
what output you get on screen
Can you also check if sqlplus is pointing to OH/bin/sqlplus or something else
________________________________
From: Clay Colburn
[mailto:clay.colburn@xxxxxxxxx<mailto:clay.colburn@xxxxxxxxx>]
Sent: Tuesday, August 17, 2010 1:53 PM
To: oracle-l; Pande, Rajendra
Subject: Re: spool creating empty file
No spool commands in the individual files.
On Tue, Aug 17, 2010 at 10:45 AM,
<rajendra.pande@xxxxxxx<mailto:rajendra.pande@xxxxxxx>> wrote:
Check the files that you are running. They may have their own spool commands
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto: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<mailto: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.
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.
--
Howard A. Latham
Sent from my Nokia N97
Other related posts:
