Re: spool command doesn't work

The error message 'error at line 1' confuses me. Isn't that a PL/SQL error?
Normally I would expect the line of code that was faulty to be echoed (or at least the first part of the line).

How are you running this? In SQLPlus? SQLWorksheet?

Geoff
Geaoff Reader
Analyst Programmer
University of Brighton

Gary Dickinson wrote:
>
> 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 Tue Jun 12 2001 - 08:05:58 CDT