Bug: Spatial Type for Oracle: st_intersects can fail with error ORA-028579

错误信息： 在执行ST_Geometry查询时候可以碰到一下情况

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
原因： 其实这是Oracle的一个Bug

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

解决方法： 用户打上Oracle补丁 升级到11.2.0.2即可解决该问题了


创建时间：2011-03-28
最近更新： 2011-03-31


【原文链接】
http://support.esrichina.com.c ... .html