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