Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-00936: missing expression
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