Re: spool creating empty file
- From: Clay Colburn <clay.colburn@xxxxxxxxx>
- To: Howard Latham <howard.latham@xxxxxxxxx>
- Date: Wed, 18 Aug 2010 07:40:46 -0700
Haha, fair enough. Login.sql isn't present in this case. I'll check to see
what is in the glogin, but because I can get it to work correctly with my test
case I'm thinking that the problem isn't there. Something must be wrong with
the files that I'm running. I'll update this thread if I find anything
interesting.
On Aug 18, 2010, at 1:39 AM, Howard Latham <howard.latham@xxxxxxxxx> wrote:
> 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:
