Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Parameter to teh spool command
try spool &name.log
-- U-NET Ltd a VIA NET.WORKS Inc company Sajid Iqbal | Mail : sajid_at_u-net.net Database DBA/Developer | Ext : 4485 U-NET Ltd | ICQ : 43903417 Warrington, Cheshire, UK | On Tue, 30 May 2000, Witold Iwaniec wrote:Received on Tue May 30 2000 - 11:03:53 CDT
> Hi all
>
> I guess it is very simple but I must be missing something...
>
> I would like to use a parameter for the spool filename so that I can
> run my script number of times and keep all spool files.
> But using:
>
> spool $1.log
> (or spool %1.log in Windows)
> does not do it.
>
> Can I do it in the sql script or do I have to go for other tools to
> generate the file name and open it?
>
> Regards
>
> Witold
> ======================================
> Witold Iwaniec
> Senior Software Developer
> NovaLIS Technologies
> wiwaniec_at_novalistech.com
> http://www.novalistech.com
> --
> Author: Witold Iwaniec
> INET: wiwaniec_at_novalistech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
![]() |
![]() |