Hi,
I have a SDO_GEOMETRY without an SRID in it, and I need to call like in the following statement :
SELECT A.G3E_FID, SDO_UTIL.TO_WKTGEOMETRY( SDO_LRS.CONVERT_TO_STD_GEOM( SDO_CS.transform( a.g3e_geometry, 28992))) g3e_geometry, 28992 srid FROM las_pt a;
if column g3e_geometry has an SRID defined this works, but if it doesn't I get the following error :
ORA-13029: Invalid SRID in the SDO_GEOMETRY object
What would be the best way to add the SRID so this statement works ?? It should be 200015.
BTW. This statement is executed from the context of Microsoft SQL-server and the g3e_geometry alias output is input for the SQL-server
geometry::STGeomFromText to create an SQL-server geometry. If there's any other way to do this, I'd be happy to.@