When creating new spatial processing functions, sometimes only the
SDO_GEOMETRY's array of ordinates (
SDO_ORDINATES) need be processed. Two functions will be created that use two different methods for processing the ordinates. These functions are drawn from real-life situations that will be described.
Two things need to be understood about the
SDO_ORDINATES attribute of the
Firstly, the name of the
SDO_GEOMETRY attribute that stores ordinate data is called
SDO_ORDINATES, which is different from the underlying data type, which is called
SDO_ORDINATE_ARRAY. This is the same as in a database table; an attribute may be called GID, but its data type
SDO_ORDINATE_ARRAY is defined as follows: ...