The preceding examples focused on the processing of one, then two geometries. In this section we will look at the processing of a collection (more than two) of SDO_GEOMETRY objects. The presentation of this type of processing will take place around solving a real world problem; creating land parcel polygons from their boundaries described by linestrings. This will require the following types of processing of collections of geometries:
Forming nodes between a collection of linestrings
Forming polygons from a collection of noded linestrings
Being inside the Oracle database, we have a limited number of methods or data types that can be used to represent a collection of geometry objects, which can be passed to our Java code for processing. These methods or collection types draw from SQL, PL/SQL and OGC SFA's geometry type hierarchy. They include:
A
REF CURSOR/result set (Java typeJava.sql.ResultSet):TYPE refcur_t IS REF CURSOR; -- or SYS_REFCURSOR...