1 Reply Latest reply on Jan 28, 2016 9:02 AM by Jim Kyle

    How do I resolve the ORA-28595 error that occurs when I try to run certain ST_GEOMETRY functions on my Oracle 11g Linux database

    Jim Kyle

      Hi,  I am trying to run the function 'select sde.st_centroid(shape) from owner.t_pole and am receiving an error;
      ORA-28595: Extproc agent: Invalid DLL Path
      ORA-06512: at "SDE.ST_GEOMETRY_SHAPLIB_PKG" line 235
      ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS" line 1398

       

      This error occurs on various other st_geometry operators but some st_geometry operators work fine.  (for example, SDE.ST_X works fine).

       

       

      I am running ArcGIS 10.2.1 and Oracle 11g (Linux). I have followed most steps I have seen on ESRI blogs, etc. to resolve the error to no avail.

       

      Is anybody else running Oracle 11g on Linux that can run a simple centroid sql statement on their database and let me know if it works?