Re: spool creating empty file

  • From: Clay Colburn <clay.colburn@xxxxxxxxx>
  • To: rajendra.pande@xxxxxxx, Oracle-L@xxxxxxxxxxxxx, andy@xxxxxxxxxxxxxxx
  • Date: Tue, 17 Aug 2010 11:10:58 -0700

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

Other related posts: