How are exceptions handled in the procedure?

Error occurred during the execution of procedure is known as exception, this can occur at server level, database level or can be raised by user on the base of some data.

This can be handled and specific tasks can be performed on getting an exception.

To handle such cases the code is written between try block and we have a catch block which will help in to manage the error, some steps can be taken if the error occurs.