Oracle Error ORA-22329: cannot alter a non-object type

Oracle Error Message

ORA-22329: cannot alter a non-object type

Reason for the Error

An attempt was made to execute ALTER TYPE on a non-object type.

Solution

Drop the non-object type first, then re-create it as an object type.