Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00920 error on simple sql query !
Thanks !
I will try that on monday, I wanna go home now :D
Maxim Demenko wrote:
> 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 - 11:02:39 CDT