Re: SqlPlus: dynamic name for a spool file
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 18 Apr 2012 17:06:53 +0200
Message-ID: <4f8ed88e$0$13221$426a74cc_at_news.free.fr>
Date: Wed, 18 Apr 2012 17:06:53 +0200
Message-ID: <4f8ed88e$0$13221$426a74cc_at_news.free.fr>
"Maikku" <kangasmaki_at_netti.fi> a écrit dans le message de news: 2144735.1356.1334755734839.JavaMail.geo-discussion-forums_at_vbuo5...
| Why is this working:
| ACCEPT TESTNUMER NUMBER PROMPT "GIVE A NUMBER> "
|
| SPOOL &TESTNUMBER._LOGNAME.LOG
|
| but this isn't:
| SPOOL LOGNAME_&TESTNUMBER..LOG
|
| It seems, that I can use a number in logname if it's in the beginning of the logname, but otherwise not. If I use char it works
both ways.
|
| I'm using SqlPlus 10.2.0.2.
|
| TIA
|
| Maija-Leena
Just execute "DEF TESTNUMBER" and you will understand. If you don't then execute "PROMPT LOGNAME_&TESTNUMBER..LOG" and I hope this time you will.
Regards
Michel
Received on Wed Apr 18 2012 - 10:06:53 CDT