It would help if Esri could add St_Geometry functions (in Oracle) for converting to and from JSON.
Similar to what we have for SDO_GEOMETRY, ArcPy, Arcade, etc.
Related:
Select SDE.ST_GEOMETRY as JSON text (using SQL)
Select JSON text of SDO_GEOMETRY using SQL
