Access ArcSDE table with SDE.ST_GEOMETRY columns

chkaufmann · Post by **chkaufmann** » Mon 02 Apr 2012 07:42

I need to read data from an Oracle ArcSDE database with UniDac. In the table I have a column of type SDE.ST_GEOMETRY.

If I execute a statement like "select * from MYTABLE", then I get a "Data type not supported" error. I can run a statement like "select ST_ASTEXT(SHAPE) from MYTABLE". But before doing that I need to know the type of the column.

How can I do this with UniDac?

cu Christian

AlexP · Post by **AlexP** » Mon 02 Apr 2012 14:27

Hello,

Presently, UniDAC doesn't support such data types. We will review the possibility of support of such types in future.

MJS · Post by **MJS** » Mon 02 Apr 2012 22:59

I've successfully used UniDac on an Oracle table with an SDO_GEOMETRY column using this syntax:

select t.shape.get_wkt() from MYTABLE t

Not sure it will work with ArcSDE though.

AlexP · Post by **AlexP** » Tue 03 Apr 2012 10:55

Hello,

The SDO_GEOMETRY type is supported by standard Oracle servers, and the ST_GEOMETRY type - only by specialized Gis-servers, therefore the given type is not implemented in the Oracle provider of UniDAC