mbhansen

EXTPROC/Oracle-index problem

Discussion created by mbhansen on Oct 29, 2013
Latest reply on Oct 31, 2013 by vangelo-esristaff
Hello,

I have installed the EXTPROC (only the st_geometry.dll part) on an Oracle 10.1.0.1 (and 10.1.0.3) and use SQL directly to my ArcSDE geodatabase instance (ArcGIS 10.1).

It works fine, except that I get an error when my SQL query uses a spatial index (like in the example below).

The error message (including SQL statement) is:

Error starting at line 1 in command:
SELECT COUNT(objectid) FROM myfeatureclass WHERE sde.st_intersects(shape, sde.st_geomfromtext('POINT(-50.7 64.6)', 4326)) = 1
Error report:
SQL Error: ORA-29902: error in executing ODCIIndexStart() routine
ORA-28579: network error during callback from external procedure agent
ORA-06512: ved "SDE.ST_GEOMETRY_SHAPELIB_PKG", linje 870
ORA-06512: ved "SDE.SPX_UTIL", linje 2927
ORA-06512: ved "SDE.SPX_UTIL", linje 3206
ORA-06512: ved "SDE.ST_DOMAIN_METHODS", linje 299
29902. 00000 -  "error in executing ODCIIndexStart() routine"
*Cause:    The execution of ODCIIndexStart routine caused an error.
*Action:   Examine the error messages produced by the indextype code and
           take appropriate action.


I really hope someone can help me solve the problem?

Thanks,
Morten

Outcomes