AnsweredAssumed Answered

Using st_geomfromwkb in PL/SQL

Question asked by topographics on Jul 17, 2017
Latest reply on Jul 18, 2017 by topographics


I'm trying to do some tests on a big table of sdo_geometries.

For that purpose I want to "translate" the oracle sdo_geometries to sde.st_geometry.


In pure SQL I can simply do that like this:

 ... sde.st_geomfromwkb(sdo_util.to_wkbgeometry(a.SHAPE), 25832) ...


In my PL/SQL function I tried it this way:


   sdegeom sde.ST_GEOMETRY;


sdegeom :=  SDE.ST_GEOMETRY_OPERATORS.st_geomfromwkb(sdo_util.to_wkbgeometry(rec.SHAPE), 25832);


But I get this error:

PLS-00224: Objekt 'SDE.ST_GEOMETRY_OPERATORS.ST_GEOMFROMWKB' muss für diese Verwendungsart Type-Funktion oder Array sein



I'm not really famliliar with PL/SQL, so any advice would be nice!


Is there a better way to translate from sdo_geom to st_geometry?