AnsweredAssumed Answered

Underlying DBMS error [ORA-00907: missing right parenthesis]

Question asked by ishan00kaushik on Jul 6, 2013
Latest reply on Jul 7, 2013 by mboeringa2010
Hi,

I am tring to query SDE Geodatabase with following query to find duplicate elments in a feature class

 IQueryFilter subiqf = new QueryFilter();  subiqf.setWhereClause(fieldName+" In (SELECT "+fieldName+" FROM "+className.getName()+"GROUP BY "+fieldName+" HAVING  Count(*)>1 )");  IFeatureCursor subresultCursor = className.search(subiqf, false);  IFeature subif = subresultCursor.nextFeature();



This qery works fine when i try for Personal geodatabase but when i try it on SDE it produces following error--

Error: AutomationException: Underlying DBMS error [ORA-00907: missing right parenthesis
] [Data.Block]
Sample failed.  Exiting...
AutomationException: 0x80041538 - Underlying DBMS error [ORA-00907: missing right parenthesis] [Data.Block] in 'esriDataSourcesGDB.SdeWorkspace.1'

and points to this line ---

IFeature subif = subresultCursor.nextFeature();


Is there something i am missing for quring SDE geodatabase else why is it only working for PGBD and not SDE ?

Outcomes