The WHEN OTHERS clause is used to trap all remaining exceptions that have not been handled by your Named System Exceptions and Named Programmer-Defined Exceptions.
The syntax for the WHEN OTHERS clause in a procedure is:
CREATE [OR REPLACE] PROCEDURE procedure_name
[ (parameter [,parameter]) ]
WHEN exception_name1 THEN
WHEN exception_name2 THEN
WHEN exception_name_n THEN
WHEN OTHERS THEN