Oracle Error PLS-00716: Attribute/method ‘string’ can occur only once in an ALTER TYPE statement

Oracle Error Message

PLS-00716: Attribute/method ‘string’ can occur only once in an ALTER TYPE statement

Reason for the Error

User attempted more than one of ADD, DROP or MODIFY on an attribute in single ALTER TYPE statement. User attempted more than one of ADD or DROP on a method in single ALTER TYPE statement.

Solution

Do only one ADD, DROP or MODIFY for an attribute in single ALTER TYPE statement. Do only one ADD or DROP for a method in single ALTER TYPE statement.