Re: why cant I spool <filename> with a variable?

On Mon, 04 Apr 2005 21:49:39 GMT, GS <spam_at_spam.com> wrote:

>spool &TS.log;
>@@temp_usage.sql;
>spool off;
>====================================================
>
>I keep getting the "SP2-0332 cannot create spool" file error, not a
>matter of permissions etc as I can spool to a file fine without the
>variable (this is a windows machine as well)
>

Add an extra dot. Your current dot is treated as delimiter now because of the variable.
For test purposes, you could precede the spool command with a define ts command, to check it's contents.

--
Sybrand Bakker, Senior Oracle DBA