Oracle Error ORA-29657: class defined in EXTERNAL NAME clause is used in another subtype

Oracle Error Message

ORA-29657: class defined in EXTERNAL NAME clause is used in another subtype

Reason for the Error

The supertype has an existing type that has the same value for the EXTERNAL NAME.

Solution

Make sure the EXTERNAL NAME clause is unique among subtypes.