topic Re: Error in the some st_geometry functions (ORA-28579) in Data Management Questions

Error in the some st_geometry functions (ORA-28579)

MarceloEdy_Peinado — Wed, 09 Jul 2014 21:27:07 GMT

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

Re: Error in the some st_geometry functions (ORA-28579)

DonOpgenorth — Tue, 12 Aug 2014 14:29:05 GMT

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

Re: Error in the some st_geometry functions (ORA-28579)

NicoleSchleifer — Wed, 04 Feb 2015 20:08:10 GMT

I'm having the exact same issue.

Did you find the resolution?