Re: ORA-00920 error on simple sql query !

samir.vds_at_googlemail.com schrieb:
> 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
>

If that is an Oracle OLAP plugin, then you can try to open a service request by oracle support. If not, you can try to rewrite the query ( may be "bestell_betrag<>erloese" to avoid the parenthesis, or "bestell_betrag != erloese" to rewrite unequal operator). The problem may also lay in the ODBC driver you use ( if you use one).

Best regards

Maxim Received on Fri Aug 11 2006 - 10:41:04 CDT