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