Multiple choice technology databases

Which exception handler must appear LAST in the exception block?

  1. User Defined Exception

  2. Predefined Internal Exception --- NO_DATA_FOUND

  3. Predefined Internal Exception --- VALUE_ERROR

  4. OTHERS Exception
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The WHEN OTHERS exception handler is a catch-all block that handles any exceptions not explicitly caught by preceding handlers. Because it catches everything, it must be the last handler in a PL/SQL exception block.

Keep practicing — related questions