Re: ORA-00936: missing expression

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 7 Sep 2001 07:23:22 +1000
Message-ID: <3b97e84f@news.iprimus.com.au>

Because the use of sub-selects in a where clause like this was a new feature of 8i.

You can use sub-selects in even more places in 9i.

That's why they are called different versions!

Regards
HJR "Alexander Shuvalov" <saturn_at_hot.ee> wrote in message news:c6f073f6.0109060628.637ac967_at_posting.google.com...
> 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.TRANSLATION a, DUMP.TRANSLATIONTX b WHERE
> a.origtext = b.trantext AND b.langcode = 'FI' AND (SELECT COUNT(*) FROM
> DUMP.TRANSLATIONTX 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 Thu Sep 06 2001 - 16:23:22 CDT