Re: spool creating empty file
- From: Clay Colburn <clay.colburn@xxxxxxxxx>
- To: Howard Latham <howard.latham@xxxxxxxxx>
- Date: Tue, 17 Aug 2010 15:50:39 -0700
I'm not familiar with login.sql, can you elaborate?
On Tue, Aug 17, 2010 at 1:30 PM, Howard Latham <howard.latham@xxxxxxxxx>wrote:
> 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:
