I am begginer on GIS, and I have loaded a shapefile to MSSQL, PostGIS and Oracle Spatial (11g)
On both MSSQL and PostGIS I could create a query to return me the WKB from the table (geometry field)
The equivalent query on my Oracle should be this one:
select l.GEOM.Get_WKB() from LINK l
This returns all records as (null). The same thing on other databases return the binary data (represented on hexadecimal)
If I try:
select l.GEOM.Get_WKT() from LINK l
it does not return the text representation.
I know the data is there, since using ADO connection I could retrieve the data from the Geom field (object) and each coordinate from the ORDINATE varray. I have used GeoRaptor to load the shp file to the database.
So, what is the right way to create a query to retrieve the WKB from Oracle Version 18.104.22.168.0?