ORA-00936: missing expression

From: Alexander Shuvalov <saturn_at_hot.ee>
Date: 6 Sep 2001 07:28:46 -0700
Message-ID: <c6f073f6.0109060628.637ac967_at_posting.google.com>

[Quoted] Hi, all!!!

[Quoted] [Quoted] 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:28:46 CEST

This message: [ Message body ]
Next message: Jon Schlatter: "Re: SQL*Plus report formatting"
Previous message: Pahyat: "Re: Oracle 8.1.7 JDBC"
Next in thread: Michel Cadot: "Re: ORA-00936: missing expression"
Reply: Michel Cadot: "Re: ORA-00936: missing expression"
Reply: Vladimir M. Zakharychev: "Re: ORA-00936: missing expression"
Reply: Howard J. Rogers: "Re: ORA-00936: missing expression"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message