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 SDO_GEOMETRY
object.
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 Integer
SDO_ORDINATE_ARRAY
is defined as follows:
Create Or Replace SDO_ORDINATE_ARRAY As VARRAY (1048576) Of Number;