NIM065648 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM065648
Submitted	March 1, 2011
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	10.0
Status	Non-Reproducible

Description

An ORA-028579 error can be encountered when executing a query with an st_geometry attribute.

Code:

SELECT objectid,
sde.st_intersection(shape,
                    (SELECT shape
                     FROM parcels                     
                     WHERE id = 4 AND cycle_type = '1')) AS shape
FROM parcels
WHERE sde.st_intersects(shape,
     (SELECT shape
      FROM parcels
      WHERE id = 4 AND cycle_type = '1')) = 1;

select objectid,
*
ERROR at line 1:
ORA-28579: network error during callback from external procedure agent
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 682
ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2496

Cause

This issue is due to an Oracle bug. Refer to My Oracle Support for more information.

Oracle Bug: 8507458 "ODCIindexstart dump on select on a column which has domain index created."

Note:
If the problem described in this article is encountered, a new folder and call stack trace file will be automatically generated by Oracle in the $ORACLE_HOME/rdbms/log/hs_core_#### folder (where #### is an auto-generated number). This call stack trace can be compared to the one mentioned in the Oracle bug, or it can be provided to Oracle to determine if the same issue  is being encountered.