In Oracle, I am trying to calclulate length for lines stored as ST_Geometry in SRID 4326 (WGS84).
Unfortunately, the ST_Length function calculates in the units of the SRID and it is not usable neither meaningful. Looking at the SDE documentation, I am surprised it does not look possible to select an output unit in geodesic meter, kilometer, miles... as in the ST_Distance function.
Is there any workaround? It look like there is a possibility with the ST_Transform on the fly. However, as soon as you transform geodesic data into planar data, there will be some sort of errors introduced because my dataset is global.
Any help will be appreciated.