Re: Problem with one sentence

The problem is that the select was in one line, braking it in multiple lines it works

Thanks

sybrandb_at_my-deja.com wrote:

> 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.
Received on Wed Aug 23 2000 - 09:00:29 CEST