Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Idea: Add a SDO_ORDINATES member function (for extracting collection elements by index)

User_1871Jun 19 2022 — edited Jul 1 2022

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

Comments

Processing

Post Details

Added on Jun 19 2022
#database-key-features, #spatial
9 comments
513 views
1 mention