I am having a problem with the following query run on Oracle 11g with SDE 10.1:
FROM mg_table mg,
FROM ct_table ct
WHERE ct.strno = 'xxx' AND ct.anno = 2015
WHERE SDE.st_intersects(mg.shape, SDE.st_buffer(c.shape, 30)) = 0
produces the following generic exception:
ORA-28579: network error during callback from external procedure agent:
ORA-06512: at 'SDE.ST_GEOMETRY_SHAPELIB_PKG', line 325
ORA-06512: at 'SDE.ST_GEOMETRY_OPERATORS', line 1331
I tried to reproduce the error on a different server with an identical database but with SDE 10.2 installed and the exception never occurs.
Does SDE 10.1 version include a different implementation of st_buffer or st_intersects respect to 10.2 or 10.3 version? Upgrading the first server to 10.3 could solve this kind of problems?