How to fix the Oracle error ORA-13345: a compound polygon geometry has fewer than five coordinates?

In this post, you’ll learn more about the Oracle ErrorORA-13345: a compound polygon geometry has fewer than five coordinates with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-13345: a compound polygon geometry has fewer than five coordinates

Reason for the Error ORA-13345: a compound polygon geometry has fewer than five coordinates

A geometry, specified as being a compound polygon, has fewer than five coordinates in its definition.

How to fix the Error ORA-13345: a compound polygon geometry has fewer than five coordinates ?

You can fix this error in Oracle by following the below steps

A compound polygon must contain at least five coordinates. A compound polygon consists of at least one arc and one line, each of which must be described using three and at least two distinct coordinates respectively. Correct the geometric definition, or set the appropriate SDO_GTYPE or SDO_ETYPE attribute for this geometry.