Re: spool creating empty file
- From: Howard Latham <howard.latham@xxxxxxxxx>
- To: clay.colburn@xxxxxxxxx
- Date: Tue, 17 Aug 2010 21:30:34 +0100
check your login.sql
On 17 August 2010 19:10, Clay Colburn <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> 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]
>> *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> 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] *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.
>>
>>
>>
>> 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:
