Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!sn-xit-03!sn-xit-08!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: why cant I spool with a variable? Date: Tue, 05 Apr 2005 00:17:51 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <66f351947eitc38bkr5e70co9acr7ktfp4@4ax.com> Reply-To: sybrandb@hccnet.verwijderdit.nl References: X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 20 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:239623 On Mon, 04 Apr 2005 21:49:39 GMT, GS 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