Oracle Exception Handling
Syntax
The general syntax for exception section:
DECLARE
declaration Section
BEGIN
some statements
EXCEPTION
WHEN exception_one THEN
DO something
WHEN exception_two THEN
DO something
WHEN exception_three THEN
DO something
WHEN OTHERS THEN
DO something
END;An exception section has to be on the end of the PL/SQL block. PL/SQL gives us the opportunity to nest blocks, then each block may have its own exception section for example:
CREATE OR REPLACE PROCEDURE nested_blocks
IS
BEGIN
some statements
BEGIN
some statements
EXCEPTION
WHEN exception_one THEN
DO something
END;
EXCEPTION
WHEN exception_two THEN
DO something
END;If exception will be raised in the nested block it should be handled in the inner exception section, but if inner exception section does not handle this exception then this exception will go to exception section of the external block.