SELECT TO_CHAR(F.ID) "Unique ID", SDO_Geom.SDO_Centroid(S.Geometry,1) "Centroid" FROM MyTable F, AnotherTable S WHERE F.ID = S.MyTable_ID
One or more layers failed to draw: MyQuery: Underlying DBMS error [ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_CENTROID' ]
MDSYS.SDO_GEOMETRY(2003,8307,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(121.54331,42.109625,121.543454,41.992575,121.700346,41.992575,121.70049,42.109625,121.54331,42.109625))
MDSYS.SDO_GEOMETRY(2001,8307,MDSYS.SDO_POINT_TYPE(121.6219,42.0511271376152,null),null,null)