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.
