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



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

Answer / guest

Cause: 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.

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00647: Integer to number conversion error

1 Answers  


RMAN-08532: channel string: restoring block(s) from datafilecopy string

1 Answers  


NNC-00420: operation not allowed

1 Answers  


NNC-00051: message content error

1 Answers  


NCR-02005: NCRF: Invalid session mode

1 Answers  






LPX-00275: can't set output/data encoding AFTER parsing

1 Answers  


PCC-00040: Unable to open listing file "string"

1 Answers  


ORA-30190: reserved for future use

1 Answers  


ORA-19613: datafile string not found in backup set

1 Answers  


ORA-13241: specified dimensionality does not match that of the data

1 Answers  


NCR-04011: NCRR: Oracle Names error

1 Answers  


NNO-00809: Unknown OCI error: number

1 Answers  


Categories