Oracle Error ORA-13340: a point geometry has more than one coordinate

Oracle Error Message

ORA-13340: a point geometry has more than one coordinate

Reason for the Error

A geometry, specified as being a point, has more than one coordinate in its definition.

Solution

A point has only one coordinate. If this geometry is intended to represent a point cluster, line, or polygon, set the appropriate SDO_GTYPE or SDO_ETYPE value. If this is a single point object, remove the extraneous coordinates from its definition.