When using the ST_INTERSECTION() function on some data with the default tolerance of 0.001, the following error message is returned, "Error ORA-28579: network error during callback from external procedure agent."

Workaround

1. Change default tolerance: Reload the feature class with the default tolerance and resolution values below:

Tolerance = 0.0001

Resolution = 0.00001

2. Use ST_Intersects function instead. Below is an example of a working query:

select SDE.ST_AsText(s1.shape)

from intersect1 s1, Intersect2 s2

where sde.st_intersects(s1.shape, s2.shape)=1

and

s2.ObjectID = 1

and

s1.objectid = 1

Schritte zur Reproduzierung