Re: Error in report based on sql query.
From: Frank <frankbo_at_interaccess.nl>
Date: Tue, 5 Sep 2000 16:27:47 +0200
Message-ID: <8p2vtm$1su$1_at_porthos.nl.uu.net>
Date: Tue, 5 Sep 2000 16:27:47 +0200
Message-ID: <8p2vtm$1su$1_at_porthos.nl.uu.net>
Just a hunch...
does '>' get translated into '>' or %25 (or something like that)?
Bug...
-- Frank <dini.f_at_adr.it> schreef in berichtnieuws 8p2t69$h8m$1_at_nnrp1.deja.com...Received on Tue Sep 05 2000 - 16:27:47 CEST
> I obtained this error on running a report based on this query:
> select B.AA_PRATICA_INT||' '||B.NRO_PRATICA_INT||' '||B.PROG_PRATICA_INT
> codice_pratica_int,
> B.progressivo,
> b.cod_bagaglio,
> A.codice_world_tracer,
> a.cognome,
> a.stato_pratica_old||' ----> '||stato_pratica Variazione_stato,
> decode(B.stato,'00','Stato Insert',
> '01','Pratica Inserita',
> '02','Pratica Elaborata',
> '05','Pratica Trasmessa',
> '07','Sospeso da Dec',
> '10','Trovato',
> '11','Ritrattato',
> '12','Sospeso',
> '15','Ritirato',
> '20','Chiusura',
> '21','Chiusura Arco',
> '23','Da Riavviare',
> '25','Riavviato') stato_singolo_bagaglio,
> a.data_stato
> FROM LFBAGAGLIO B,LF_VARIAZ_PRATICHE_TAB A
> WHERE a.stato_pratica_old not like '%NEW%' and
> a.stato_pratica_old is not null and
> B.AA_PRATICA_INT||' '||B.NRO_PRATICA_INT||' '||B.PROG_PRATICA_INT
> = a.codice_interno and
> a.data_stato > sysdate -1/24;
> ORA-00911: invalid character
> ERROR WWV-08300 Failed to parse as LOFO - select
> B.AA_PRATICA_INT||'
> '||B.NRO_PRATICA_INT||'
> '||B.PROG_PRATICA_INT
> codice_pratica_int, B.progressivo,
> b.cod_bagaglio,
> A.codice_world_tracer,
> a.cognome, a.stato_pratica_old||'
> ---->
> '||stato_pratica Variazione_stato,
> decode(B
>
> Why?
> The same query goes well on sqlplus.
> Thanks a lot.
>
> Francesco Dini
> >
> Sent via Deja.com http://www.deja.com/
> Before you buy.