Re: ORA-00920 error on simple sql query !

Actually, I'm not using sqlplus. I'm using the sql query in an Excel Sheet which obtains the data from the oracle databse over an Excel Plug-In. Here's the relevant part ofthe log:

0,00: Query.OpenDataSet: type=1

              > select client , kunde , kunden_name , projekt , projekt_name ,

                      angebot , auftrag , bestell_betrag ,
bestell_datum ,
                      erloese , konto , konto_name , buch_periode ,
buch_datum
                      , beleg , lstart , projekt_ende ,
projekt_erstellt ,
                      projekt_status
                from HAUFB0363
                where ( bestell_betrag - erloese ) <> 0
                order by kunde , projekt
16:11:31      > ORA-00920: Ungültiger relationaler Operator

16:11:31      > ERROR -1: Can't open cursor

We're running Oracle 9i 9.2.0.7.0

Maxim Demenko wrote:
> samir.vds_at_googlemail.com schrieb:
> > Hey,
> >
> > I just started my first job last week.
> >
> > Anyway, I want to run the following sql query on an Oracle database:
> >
> > select client , kunde , kunden_name , projekt , projekt_name ,
> > angebot , auftrag , bestell_betrag ,
> > bestell_datum ,
> > erloese , konto , konto_name , buch_periode ,
> > buch_datum
> > , beleg , lstart , projekt_ende ,
> > projekt_erstellt ,
> > projekt_status
> > from HAUFB0363
> > where ( bestell_betrag - erloese ) <> 0
> >
> > I get the error message: ORA-00920 invalid relational operator.
> > But with my SQL tool called "TOAD" the query works fine !
> >
> >
> > I'd appreciate any help
> >
> > Samir
> >
> I don't see any syntactical errors in your query. Could you provide the
> output from sqlplus session where you get this error (i assume, you use
> sqlplus).

>