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

TNS-01182: Listener rejected registration of service "string"

1 Answers  


ORA-06504: PL/SQL: Return types of Result Set variables or query do not match

1 Answers  


LPX-00215: processing instruction did not end in "?>"

1 Answers  


ORA-26660: Invalid action context value for string

1 Answers  


ORA-16018: cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

1 Answers  






LPX-00220: the string "]]>" cannot occur in character data

1 Answers  


QSM-02175: some query block in UNION ALL MV is not fast refreshable

1 Answers  


TNS-00038: INTCTL: Poorly formed address or command string

1 Answers  


ORA-25288: AQ HTTP propagation encountered error, status-code number, string

1 Answers  


ORA-23451: flavor string already defined for object group "string"."string"

1 Answers  


ORA-24100: error in ktz testing layer

1 Answers  


PLS-00135: Pragma string expects 3rd argument to be an identifier, string or numeric literal

1 Answers  


Categories