RE: spool creating empty file

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Tue, 17 Aug 2010 19:04:53 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F583FCCBB_at_AAPQMAILBX02V.proque.st>



http://download.oracle.com/docs/cd/B13789_01/server.101/b12170/ch3.htm#i1133106

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Clay Colburn Sent: Tuesday, August 17, 2010 6:51 PM
To: Howard Latham
Cc: rajendra.pande_at_ubs.com; Oracle-L_at_freelists.org; andy_at_oracledepot.com 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_at_gmail.com<mailto:howard.latham_at_gmail.com>> wrote: check your login.sql

On 17 August 2010 19:10, Clay Colburn <clay.colburn_at_gmail.com<mailto:clay.colburn_at_gmail.com>> 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_at_ubs.com<mailto:rajendra.pande_at_ubs.com>> 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_at_gmail.com<mailto:clay.colburn_at_gmail.com>] 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_at_ubs.com<mailto:rajendra.pande_at_ubs.com>> wrote: Check the files that you are running. They may have their own spool commands



From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of Clay Colburn Sent: Tuesday, August 17, 2010 1:42 PM
To: Oracle-L_at_freelists.org<mailto:Oracle-L_at_freelists.org> 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
_at_/tmp/myfile.sql
_at_/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


--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 17 2010 - 18:04:53 CDT

Original text of this message