More succinct ST_GEOMETRY function calls in PL/SQL

Bud — Sat, 21 May 2022 16:29:18 GMT

Function calls in PL/SQL are quite verbose.

In a plain SQL query, we can do this…

sde.st_geometryN_f(shape,1)

…but in a custom PL/SQL function, we have to do this:

sde.st_geometry_operators.st_geometryN_f(shape,1)

Which makes the function calls hard to read when we string multiple functions together:

-- startpoint X of a multi-part polyline
sde.st_geometry_operators.st_x_f(sde.st_geometry_operators.st_startpoint_f(sde.st_geometry_operators.st_geometryN_f(shape,1)));

More info: Use SDE.ST_GEOMETRY functions in a custom function

Could Esri give us a shorter way to make SDE.ST_GEOMETRY function calls in PL/SQL?

idea More succinct ST_GEOMETRY function calls in PL/SQL in ArcGIS Enterprise Ideas

More succinct ST_GEOMETRY function calls in PL/SQL