Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00936: missing expression

ORA-00936: missing expression

From: Alexander Shuvalov <saturn_at_hot.ee>
Date: 6 Sep 2001 07:28:46 -0700
Message-ID: <c6f073f6.0109060628.637ac967@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 - 09:28:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US