Toad World® Forums

Unable to view spatial data values


#1

Hi All,

I currently use Toad Data Point version 3.2.0.916 and one of my database tables includes spatial data which is displayed as “Devart.Data.Oracle.OracleObject” in Toad. However, when I view this same database using Oracle SQL Developer, this same data is displayed as “MDSYS.SDO_GEOMETRY(2003,262148…)” with a list of coordinates.

My question is, how can I get this to display in Toad?

Appreciate any help I can get, thanks.


#2

Please update to the latest version of TDP. We have added support for this Oracle datatype.


#3

Can the geometry array values be parsed out in a cross connection query?


#4

The Geometery type is not currently supported in X-Query.