Re: Spool filename Extension URGENT

From: Peter Laursen <pl_at_mail1.remove.this.stofanet.dk>
Date: Wed, 10 Jan 2001 17:20:52 +0100
Message-ID: <d0076.348$y6.16738@news101.telia.com>

sanjayraj6844_at_my-deja.com skrev i meddelelsen <93hudp$s1r$1_at_nnrp1.deja.com>...
>URGENT. Can anybody help
>
>I have created the following script to spool the results to a file. I
>want the extension of the spool filename to be .TXT or something other
>than .LST. Is it possible & How?
>
>set pages 0 linesize 200
>accept territoryid char format 'A10'-
>prompt'Enter territoryid :'
>spool /voyager/data1/NEW/detail prof in &territoryid
>select

Well, you are not telling what OS or SQL-plus version you are using. Naming the spoolfile works fine here:
spool name.TXT

Peter Laursen. Received on Wed Jan 10 2001 - 10:20:52 CST