Select to view content in your preferred language

Error in the some st_geometry functions (ORA-28579)

07-09-2014 02:27 PM
New Contributor III


I have problem when I try to use some st_geometry functions.

One of them is the st_buffer()

In the resource center there are a example for use it (st_buffer):

But, look that happened when I try to run the query using sqlplus: 

SQL> SELECT "Sensitive Areas", "Hazardous Sites"

  2  FROM sensitive_areas sa, hazardous_sites hs

  3  WHERE sde.st_overlaps (, sde.st_buffer (hs.location, 0.01)) = 1;

SELECT "Sensitive Areas", "Hazardous Sites"


ERROR at line 1:

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 1213

The curious is that others functions like st_relate works fine!

Anyone can help me?

ArcSDE 10.1 for Linux
Oracle 11g (

Thanks and regards.

Marcelo E. Peinado

Optimus GIS & IT Solutions

0 Kudos
2 Replies
Esri Contributor

I've moved your post into the  Managing Data space.  You will get a much better answer here as the GeoNet Help is intended for community help and feedback. I have also added in a few additional tags. You can see more
on the community structure, and what topics are under each space from the following documents:

GeoNet Community Structure

ArcGIS Discussion Forums Migration Strategy



0 Kudos
New Contributor II

I'm having the exact same issue.

Did you find the resolution?

0 Kudos