PLS-00483: exception 'string' may appear in at most one
exception handler in this block



PLS-00483: exception 'string' may appear in at most one exception handler in this block..

Answer / guest

Cause: An exception appears in two different WHEN clauses
(that is, two different exception handlers) in the
exception-handling part of a PL/SQL block or subprogram.

Action: Remove one of the references to the exception.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00958: Name nodes freed: number

1 Answers  


ORA-12156: TNS:tried to reset line from incorrect state

1 Answers  


RMAN-00550: parser package failed to load

1 Answers  


ORA-30772: opaque types do not have default constructors

1 Answers  


RMAN-06180: incremental backups require Enterprise Edition

1 Answers  


ORA-07200: slsid: oracle_sid not set.

1 Answers  


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

1 Answers  


ORA-01304: subordinate process error. Check alert and trace logs

1 Answers  


NNL-00511: Shows or sets the server's system query authority requirements

1 Answers  


ORA-24089: AQ Agent string already exists

1 Answers  


ORA-12070: cannot offline instantiate materialized view "string"."string"

1 Answers  


ORA-02185: a token other than WORK follows COMMIT

1 Answers   IBM,


Categories