AnsweredAssumed Answered

Error in the some st_geometry functions (ORA-28579)

Question asked by mpeinado on Jul 9, 2014
Latest reply on Feb 4, 2015 by nschleifer5555

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

Outcomes