Hi Team,
I am trying to convert SDO_Geometry to ST_Geometry by using
SDE.ST_GEOMFROMTEXT(SDO_GEOMETRY.GET_WKT(SHAPE),4326) and
SDE.ST_GEOMFROMWKB(SDO_GEOMETRY.GET_WKB(SHAPE)),4326).
When i used WKT - i am getting error as Ora-20004 Error generating shape from text (-2035)
Whereas if i used WKB - not getting any error, but polygon area is coming as 0. It means conversion not happened.
Please help me to understand - why we are getting this error and what exactly the differenece between those WKT and WKB function usage.
Thanks in advance.
