to_gmlgeometry failed, details..
425666Dec 6 2004 — edited Dec 8 2004hi, i try follwing after installed 10g:
SELECT SDO_CS.TRANSFORM(sdo_geometry(2001, 8307,sdo_point_type(-80, 70, null),sdo_elem_info_array(1,1,1), sdo_ordinate_array(10, 10)),1) from dual;
--ok...
SELECT SDO_UTIL.GETNUMELEM(sdo_geometry(2001, 8307,sdo_point_type(-80, 70, null),sdo_elem_info_array(1,1,1), sdo_ordinate_array(10, 10)) )from dual;
--ok...
SELECT SDO_UTIL.TO_GMLGEOMETRY(sdo_geometry(2001, 8307,sdo_point_type(-80, 70, null),sdo_elem_info_array(1,1,1), sdo_ordinate_array(10, 10))) from dual;
---ERROR:
---ORA-04063: type body "MDSYS.SDO_GEOMETRY" error
---ORA-06508: PL/SQL: can't find ...
---ORA-06512: å¨ "MDSYS.SDO_UTIL", line 1326