AnsweredAssumed Answered

SQL Syntax

Question asked by bbirbo2008 on May 28, 2015
Latest reply on Jun 2, 2015 by bbirbo2008

Hi.

 

I have an oracle table with SDO geometry and i am publishing this as a Feature service. I have registered the Database connection on the ArcGIS server and it publishes without any warnings.

 

When i query the layer from arcmap (on the MXD that i use to publish) it will accept Oracle SQL syntax as query definition.

When i query the feature layer from arcmap (after adding it as a feature layer from arcgis server) it will not accept Oracle SQL Syntax.

 

What exactly is happening to the SQL Query on ArcGIS server ?

 

Using ArcGIS Server 10.2.2

 

Thanks.

Outcomes