spool command doesn't work

From: Gary Dickinson <gd_at_interchange.ubc.ca>
Date: Thu, 7 Jun 2001 11:11:20 -0700
Message-ID: <9fog0o$ih$1@nntp.itservices.ubc.ca>

Hi. I'm having problems spooling my output to a file. Here's the code i have (it's a little crude but it works).

spool data
select to_char(strikedate,'yyyy/mm/dd hh24:mi'), latitude, longitude,amplitude
from ltng_strikes
where latitude between '&SouthLatitude' and '&NorthLatitude' and longitude between '&WestLongitude' and '&EastLongitude' and strikedate between
to_date('&startdate 00:00', 'yyyy/mm/dd hh24:mi') and to_date('&enddate 23:59', 'yyyy/mm/dd hh24:mi') spool off
/

When I run the script, I get the error:

ERROR at line 1:
ORA-00900: invalid SQL statement

This has been stumping me. I'm a rookie at SQL. Any help would be appreciated.

Thanks

Gary Received on Thu Jun 07 2001 - 13:11:20 CDT