An exception is an abnormal situation which becomes an obstacle in the normal flow of the program.
When you are writing a PL/SQL block which is an procedural extension of SQL, there comes the following sequence of blocks:
declare
< variables,cursors etc>
begin
< body of the PL/SQL block>
exception
end
in the exception block … Read more