[fdo-users] FDO 3.5 ArcSDE Provider Oracle ORA-00920

[maland]

The following C# code:

<snippet>
select.SetFilter("( XROW = 0 OR XROW = 1) AND YROW = 0");
IFeatureReader reader = select.Execute();
  while (reader.ReadNext())
</snippet>

results in: 
Stream fetch failed.
   at OSGeo.FDO.Commands.Feature.IReaderImp.ReadNext()

Nesting down the inner exceptions reveals the 
"Invalid SQL syntax (-42)" and "ORA-00920: invalid relational operator"

I'm tried this both in 3.5rc1 and 3.4.1. We are using Oracle 11.1.

It seems like the ArcSDE provider don't allow me to have combinations of OR
and AND operators. Trying the exact same filter using i.e. SHP provider runs
perferctly.

Any ideas what is going on?

Regards
Henning Maland

-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/FDO-3-5-ArcSDE-Provider-Oracle-ORA-00920-tp5587468p5587468.html
Sent from the FDO Users mailing list archive at Nabble.com.