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.
FYI: I got the error code information from https://support.esri.com/en-us/knowledge-base/faq-what-are-the-error-codes-returned-from-the-shape-e... .