SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 6 09:51:59 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SELECT IBOW.SEAGRASS_RL13.OBJECTID, IBOW.SEAGRASS_RL13.RLSTATUS FROM IBOW.SEAGRASS_RL13, IBOW.ITALYF2_REV1_AU WHERE SDE.ST_INTERSECTS (IBOW.ITALYF2_REV1_AU.SHAPE, IBOW.SEAGRASS_RL13.SHAPE) = 1; SELECT * ERROR at line 1: ORA-28579: network error during callback from external procedure agent ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 100 ORA-06512: at "SDE.ST_RELATION_OPERATORS", line 340
SELECT IBOW.SEAGRASS_RL13.OBJECTID, IBOW.SEAGRASS_RL13.RLSTATUS FROM IBOW.SEAGRASS_RL13, IBOW.ITALYF2_REV1_AU WHERE SDE.ST_INTERSECTS (IBOW.ITALYF2_REV1_AU.SHAPE, IBOW.SEAGRASS_RL13.SHAPE) = 1 AND IBOW.SEAGRASS_RL13.OBJECTID IN (27); OBJECTID RLSTATUS ------------------------------------------------------------------------------------------ 27 LC
Hi Stefano,
Are you using 11.2.0.3 or 12.2.0.3 (is this released yet)? From what I can tell it is fixed in a patch set on top of 11.2.0.2 and in 12.1.0.1. I suggest checking the info in this KB article and then following up with Oracle if you get an hs_core file as described:
KB38823 - Bug: Spatial Type for Oracle: st_intersects can fail with error ORA-028579
Otherwise yes, please open an incident with your local distributor.
Thanks.
we are on 11.2.0.3 and experiencing this issue after the 10.2.2 upgrade. Any solutions?