Unable to view spatial data values

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.

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

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

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