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

maland hma at powel.com
Thu Sep 30 07:56:42 EDT 2010

The following C# code:

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

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

Any ideas what is going on?

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.

More information about the fdo-users mailing list