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