Oracle Error ORA-54540: at least one element must be a surface or solid

Oracle Error Message

ORA-54540: at least one element must be a surface or solid

Reason for the Error

One of the geometries had holes, and the geometries were neither (A) simple, composite, or multisurfaces, or (B) simple, composite, or multisolids. (Surfaces and solids are the only geometries that can have holes. Points and curves cannot have holes.)

Solution

Ensure that each geometry having holes is a surface or solid (simple, composite, or multi).