Re: ORA-00936: missing expression
Date: Fri, 7 Sep 2001 07:23:22 +1000
Message-ID: <3b97e84f_at_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 - 23:23:22 CEST