Oracle11.2.0.1 execute st

Support. esri. comenknowledgebasetecharticlesdetail38823 system environment when ArcSDE9.3.1 and ArcSDE10 use Oracle11.2.0.1 to execute a query on ST_Geometry, A Ora-28579 error is reported, this error was also raised by many users before, and it is always the kind of occasional error. SELECTob

Http://support.esri.com/en/knowledgebase/techarticles/detail/38823 system environment in ArcSDE9.3.1 and ArcSDE10 when using Oracle11.2.0.1 to execute the query on ST_Geometry, The Ora-28579 error is reported, this error in the previous user mentioned more, and it is always the kind of occasional error. SELECT ob

Http://support.esri.com/en/knowledgebase/techarticles/detail/38823

The system environment in ArcSDE9.3.1 and ArcSDE10 when using Oracle11.2.0.1 to execute the query on ST_Geometry, The Ora-28579 error is reported, this error in the past the user mentioned more, and always belongs to the kind of occasional errors.

SELECT objectid,sde.st_interp(shape,                    (SELECT shape                     FROM parcels                                          WHERE id = 4 AND cycle_type = '1')) AS shapeFROM parcelsWHERE 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 agentORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 682ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2496

This is actually a Bug in Oracle.

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

You can fix this problem by patching Oracle to 11.2.0.2.