Can't display Oracle St_geometry column

jed
2013-05-23
2013-05-23
  • jed
    jed
    2013-05-23

    Hi, can someone please advice if GeoRaptor can display MDSYS.ST_GEOMETRY type columns? It was working fine with SDO_GEOMETRY columns but giving an error when I tried to use it in a table with ST_GEOMETRY. Please note that the st_geometry column was derived from a table with sdo_geometry column type.

    Error that I received is:
    (GeoRaptor) error: Error...
    ORA-00904: "A"."GEOM"."SDO_GTYPE": invalid identifier

    ... retrieving layer_gtype(schema.WLAYER.GEOM).
    (GeoRaptor) warn: java.lang.Exception: Error...
    ORA-00904: "A"."GEOM"."SDO_GTYPE": invalid identifier

    ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.

    Sample st_geometry values:
    MDSYS.ST_GEOMETRY(MDSYS.SDO_GEOMETRY(2001,8307,MDSYS.SDO_POINT_TYPE(-93.3319910897273,29.4006979386483,NULL),NULL,NULL))

    Appreciate any help on this.

    Cheers,
    jed

     
    Last edit: jed 2013-05-23