Re: spool command doesn't work

Hi again. I tried the suggestions in the replies and the script still doesn't work. This has been stumping me all day. Please help.

Thanks again

Gary

Gary Dickinson <gd_at_interchange.ubc.ca> wrote in message news:9fog0o$ih$1_at_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 - 23:10:00 CDT