Database Software

Hi All,

I am just looking out for a best way to remove inner rings from a complex geometry of SDO_GEOMETRY using ORACLE packages. I have a complex geometry called MAINGEOM which is having two disjoint elements ELEM1, ELEM2 and each element will have a hole/inner ring completely inside the ELEM1 and ELEM2 respectively.

I just wanted to remove the two holes/inner rings from each ELEMs.

Initially, I have planned to collect all individual rings which are not inside the element using SDO_UTIL.EXTRACT and collecting them into a collection and subsequently appending all of them to the first element in the collection to prepare a new geometry.

FOR rec in c1
LOOP
new_g := SDO_UTIL.APPEND(new_g, rec.GEOM);
END LOOP;

I feel, this a crude way of solving the problem. I doubt that there should be an existing SDO packages to remove the inner/required rings/elements.

Can anyone please help me to solve this problem and let me know if further information is required.

Regards,
Kumar