Oracle Error Message
ORA-22331: cannot alter an incomplete type
Reason for the Error
An attempt was made to perform ALTER TYPE on an incomplete type.
Solution
Use CREATE TYPE to completely define the original type before executing the ALTER TYPE.