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

ORA-24350: OCI call not allowed

1 Answers  


ORA-10918: TABLESPACE GROUP name cannot be the same as tablespace name

1 Answers  


ORA-25137: Data value out of range

1 Answers  


ORA-07481: snlmatt: cannot attach to lock manager instance.

1 Answers  


ORA-31615: routine string received this error: string

1 Answers  






ORA-29804: missing DATA keyword

1 Answers  


DRG-12602: index owner does not have access to user datastore procedure: string

1 Answers  


ORA-24850: failed to startup shared subsystem

1 Answers  


ORA-26083: unsupported direct path stream version string

1 Answers  


ORA-27205: skgfpcn: sbtpccancel returned error

1 Answers  


PCC-02413: Number of attributes does not match number of host variables

1 Answers  


DRG-12303: cannot add more than 99 indexes to an index set

1 Answers  


Categories