Function to convert from ST_GEOMETRY subtype to supertype

[Bud]

ST_GEOMETRY; Oracle:

Could ESRI create a function to convert directly from the ST_POINT subtype to the ST_GEOMETRY supertype?

That would solve these issues:

• Bug: Unable to define a query layer in ArcGIS where the data source uses an st_geometry subtype in O...
• Get ArcGIS to recognize ST_POINT
• Use TREAT() function to convert UDT subtype to supertype

I'm aware that there is a quick-and-dirty workaround, where we can convert from subtype to text to supertype (or use well-known binary instead of text). But that workaround is ugly and slow. It would be better to have a more robust & performant solution.

[Bud]

In a reply to Create NIL (zero vertex) geometry, I mention that the bug has been updated. It now suggests that we use the st_geometry constructor to convert from subtypes to supertypes. Which seems to work for converting [SDE.ST_POLYFROMTEXT] to [SDE.ST_GEOMETRY].

But that doesn't help me when converting [ST_POINT] subtype to [ST_GEOMETRY] supertype: