I would like to loop through the vertices in a SHAPE/GEOMETRY column in a user-defined data type (ESRI's version of
ST_GEOMETRY). I've posted the details in a GIS SE post here: https://gis.stackexchange.com/questions/209894/update-sde-st-geometry-m-values-to-cumulative-distance-using-oracle-sql
I believe this would normally be done in a stored procedure (probably in conjunction with the
ST_PointN) . However, I'm merely a data analyst, not a DBA, and do not have
CREATE PROCEDURE permissions, so I can't make a stored procedure. Additionally, in my company/organization, a request for a procedure to be made would either be rejected or take years to be implemented.
So I'm wondering, as an alternative to creating a stored procedure, if I could loop through the vertices within an SQL update statement instead?
Oracle 12c (188.8.131.52.0)