Im trying to get data inside the table which is below.
CREATE TABLE Eshot (
eshotNumber NUMBER,
eshot_geo_location SDO_GEOMETRY);
Using this query returns unsupported data type;
Select e.eshot_geo_location from Eshot e;
Inserted values example
INSERT INTO Eshot VALUES(476,SDO_GEOMETRY(2001, 8307,
SDO_POINT_TYPE(38.3678709,27.1824648,NULL), NULL, NULL));
How to make cast to grab data correctly? Thanks in advance