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