Devart Forums

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

Hello,

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

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.

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