MSDAORA problem...

From: Alexandar Srdic <brasyu_at_flashmail.com>
Date: Tue, 14 May 2002 11:22:23 +0200
Message-ID: <3ce0d7a5@news.mhogaming.com>

When trying to execute over msdaora this statement

SELECT DISTINCT Mitarbeiter.vdbTimeStamp, Mitarbeiter.ObjectID, Mitarbeiter.Name, Mitarbeiter.Vorname FROM Firma,Mitarbeiter WHERE Firma.ObjectID(+) = Mitarbeiter.FirmaR0001 AND
(PERBIT.ASSQL2ORA.IN_RANGE_CNT((NVL (Firma.Firmennummer,
'')),'1680000','1680600') = -1 OR PERBIT.ASSQL2ORA.IN_RANGE_CNT((NVL
(Firma.Firmennummer, '')),'1700000','1720000') = -1 OR
PERBIT.ASSQL2ORA.IS_IN_LIST(Mitarbeiter.BetriebszugJahre, '0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15') = -1 ) ORDER BY Mitarbeiter.Name, Mitarbeiter.Vorname

i get an error (ORA-00904 bad column name).

Same statement is executed without problems over sql+worksheet, toad etc. !!
meaning: sp and statement is correct.

Any ideas what is causing this problem? Solution :) ?

10x

Alex Received on Tue May 14 2002 - 04:22:23 CDT