AnsweredAssumed Answered

Can 10.2 answer Oracle where clause?

Question asked by filipkral on Mar 3, 2014
Latest reply on Mar 4, 2014 by mboeringa2010
Hi, I am having trouble implementing some functionality we have on our 9.3 and 10.0 servers with version 10.2 (all internal servers so cannot share URLs)

I need to run a query against a feature class stored in Oracle (ArcSDE 9.3) with where clause that reads something like this (is generated from a mouse-click):

sdo_nn(shape, mdsys.sdo_geometry(2001, 81989, mdsys.sdo_point_type(385878.8,247670.9,null),null,null), 'sdo_num_res=1', 1) = 'TRUE'  AND  sdo_within_distance(shape , mdsys.sdo_geometry(2001, 81989, mdsys.sdo_point_type(385878.8,247670.9, null), null, null),'distance=250 UNIT=M') = 'TRUE'

We use this to get features that are within certain distance from a user defined (clicked) point in our JavaScript app, it has been much faster than using Esri spatial filters.

If I use this where clause in the HTML interface of query tasks in services directories, it works for the services published from ArcGIS Server 9.3 and 10.0, but for the service at 10.2 i get:
code: 400, message: "Unable to complete operation."

I would appreciate any help.