Re: ORA-00936: missing expression
Date: Tue, 04 Sep 2001 12:11:35 GMT
Message-ID: <Xx3l7.4638$1s1.55390_at_typhoon.jacksonville.mediaone.net>
have you verified that 8.0.5 supports embedded SQL in the where clause, namely,
WHERE ... (SELECT COUNT(*) FROM
DUMP.YTRANSLATIONTX WHERE langcode = 'EN' AND txtcode = b.txtcode)>0 ...
"Alexander Shuvalov" <saturnxxx_at_hot.ee> wrote in message
news:3b94a7ce$1_at_news.infonet.ee...
> Hi, all!!!
>
> Why do I get the following error: ORA-00936: missing expression, when
> exectuing this command on Oracle 8.0.5 server? The command is: SELECT
> a.txtcode, b.txtcode FROM W76.YTRANSLATION a, DUMP.YTRANSLATIONTX b WHERE
> a.origtext = b.trantext AND b.langcode = 'FI' AND (SELECT COUNT(*) FROM
> DUMP.YTRANSLATIONTX WHERE langcode = 'EN' AND txtcode = b.txtcode)>0. But
> the same command works fine on ORacle 8.1.6 server!!!
>
> What is the problem here?
>
> TIA
>
>
>
Received on Tue Sep 04 2001 - 14:11:35 CEST