Re: spool creating empty file
- From: Clay Colburn <clay.colburn@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>, rajendra.pande@xxxxxxx
- Date: Tue, 17 Aug 2010 10:52:47 -0700
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.
>
Other related posts:
