select ST_Boundary (shape) from polygon_table where country like '%usa%'
Solved! Go to Solution.
SELECT SDE.ST_asText(SDE.ST_AGGR_UNION(SHAPE)) UNION_SHAPE FROM POLYGON_TABLE
ORA-06553: PLS-306: wrong number or types of arguments in call to 'ST_AGGR_UNION'
SET EXTPROC_DLLS=ONLY:C:\\oracle\\extproc_libs\\st_shapelib.dll
CREATE OR REPLACE LIBRARY st_shapelib AS 'c:\oracle\extproc_libs\st_shapelib.dll';
SELECT SDE.ST_AGGR_UNION(sde.st_geomfromwkb(sdo_geometry.get_wkb(shape),2056)) FROM POLYGON_TABLE
SQL Error: ORA-28579: network error during callback from external procedure agent
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 620
ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2245
ORA-06512: at "SDE.STGEOM_AGGR_UNION", line 1
28579. 00000 - "network error during callback from external procedure agent"
*Cause: An internal network error occurred while trying to execute a
callback to the Oracle server from the user's 3GL routine.
*Action: Contact Oracle customer support.
Thx a lot. We can't use ST_GEOMETRY, since we access the data also via Java using Hibernate. For this we use Hibernate-Spatial, which provides support for SDO_GEOMETRY, but not ST_GEOMETRY. We couldn't find any Hibernate Provider for ST_GEOMETRY at all. We actually had to spend some time for evaluation how to integrate Java/ArcSDE/Oracle, since there is not much documentation about best practises. One approach would have been using ST_GEOMETRY along with Java SDE API, but ESRI says this API won't be supported after 10.2.
ESRI Geometry API for Java