Error in the some st_geometry functions (ORA-28579)

4826
2
07-09-2014 02:27 PM
Highlighted
New Contributor II

Hello,

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):

http://resources.arcgis.com/en/help/main/10.1/index.html#/ST_Buffer/006z0000003z000000/

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

SQL> SELECT sa.id "Sensitive Areas", hs.name "Hazardous Sites"

  2  FROM sensitive_areas sa, hazardous_sites hs

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

SELECT sa.id "Sensitive Areas", hs.name "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 (11.2.0.3)


Thanks and regards.

Marcelo E. Peinado

Optimus GIS & IT Solutions

Reply
0 Kudos
2 Replies
Highlighted
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

Thanks!

Don

Reply
0 Kudos
Highlighted
New Contributor II

I'm having the exact same issue.

Did you find the resolution?

Reply
0 Kudos