SqlPlus: dynamic name for a spool file
From: Maikku <kangasmaki_at_netti.fi>
Date: Wed, 18 Apr 2012 06:28:54 -0700 (PDT)
Message-ID: <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.
Date: Wed, 18 Apr 2012 06:28:54 -0700 (PDT)
Message-ID: <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 Received on Wed Apr 18 2012 - 08:28:54 CDT