Re: spool creating empty file

Oh come on ! - RTFM!!!!
Oh well as its summer

If you create a login.sql in the directory when you invoke sqlplus it will
always be run.
There's also a glogin (global) that is in a specific place for each OS. This
will also be run. Very useful but also risky if someone changes it.


On 17 August 2010 23:50, Clay Colburn <clay.colburn@xxxxxxxxx> wrote:

> 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
>>
>>
>


-- 
Howard A. Latham

Sent from my Nokia N97

Other related posts: