Re: Problem with one sentence

In article <39A0E299.D58C2AE3_at_idtoki.com>,   =?iso-8859-1?Q?I=F1igo?= Serrano Llona <i.serrano_at_idtoki.com> wrote:
> Hello
>
> I have a proble with one sentence, it works in SQL Server 7 but not in
> Oracle 7.3.4 and I don´t know what is the problem.
>
> The sentence is
>
> SELECT
>
>
CODESCes,COURL,prNOMBes,dencores,DEPARTAMENTOS.DECODCOMP,teNOMBes,COVENT ANA
>
> FROM prodservicios, COMPPROD, TEMAS,
 COMPTEM,COMPONENTES,departamentos
>
> WHERE 1=COMPTEM.CTCODTEM AND COMPPROD.CPCODPS=PRODSERVICIOS.PRCODPS
> AND 1=COMPPROD.CPCODps AND COMPONENTES.COCoDCOMP=COMPPROD.CPCODCOMP
 AND
> COMPTEM.CTCODTEM=TEMAS.TECODTEM AND
> componentes.cocdpto=departamentos.decoddep AND
> COMPONENTES.COCODCOMP=COMPTEM.CTCODCOMP AND COes=1 AND COACTIVO=1
>
> ORDER BY PRORDEN, CODESCes
>
> The SQL Plus say:
>
> ERROR at line 2:
> ORA-00920: operador relacional no válido ("Relational operator
 not
> valid")
>
> Thanks
>
> Iñigo
>
> ----------------------En Castellano------------------
>
> Hola
>
> Tengo un problema con una sentencia en Oracle 7.3.4 que funciona
> perfectamente en SQL Server 7 y no tengo ni idea de porque falla en
> Oracle
>
> La sentencia es
>
> SELECT
>
>
CODESCes,COURL,prNOMBes,dencores,DEPARTAMENTOS.DECODCOMP,teNOMBes,COVENT ANA
>
> FROM prodservicios, COMPPROD, TEMAS,
 COMPTEM,COMPONENTES,departamentos
>
> WHERE 1=COMPTEM.CTCODTEM AND COMPPROD.CPCODPS=PRODSERVICIOS.PRCODPS
> AND 1=COMPPROD.CPCODps AND COMPONENTES.COCoDCOMP=COMPPROD.CPCODCOMP
 AND
> COMPTEM.CTCODTEM=TEMAS.TECODTEM AND
> componentes.cocdpto=departamentos.decoddep AND
> COMPONENTES.COCODCOMP=COMPTEM.CTCODCOMP AND COes=1 AND COACTIVO=1
>
> ORDER BY PRORDEN, CODESCes
>
> Cuando lo ejecuto en SQL Plus me dice
>
> ERROR at line 2:
> ORA-00920: operador relacional no válido
>
> Alguien sabe cual puede ser el problema
>
> Gracias
>
> Iñigo
>
>

Are there *really* blank lines in your statement as shown above? Blank lines are not allowed in Oracle SQL.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.