Oracle 18c:
When we try to extract SDO_ORDINATES elements by index...such as ordinate (1):
select sdo_geometry('linestring(1 2, 3 4, 5 6)').sdo_ordinates(1)
from dual
Error:
ORA-00904: "MDSYS"."SDO_GEOMETRY"."SDO_ORDINATES": invalid identifier
...the SQL engine processes the syntax as a call to a member function in the form of object_type.member_function(argument) .
There is no SDO_ORDINATES member function of the SDO_GEOMETRY data type, so the result is an error:
ORA-00904: "MDSYS"."SDO_GEOMETRY"."SDO_ORDINATES": invalid identifier
Could an SDO_ORDINATES member function be added to SDO_GEOMETRY to make it easier to extract SDO_ORDINATES elements by index?
Source: https://stackoverflow.com/a/72672702/5576771