12. Stored procedure with exception handling

Exception handling:

Exception handlers:

Continue handler:

Exit handler:

Single error handler:

Multiple errors multiple handlers

SQL exception:

Control flow

Explanation of the code

Shipped Status                         Cancelled Status                     On Hold Status

Application to identify the fraud:

Create procedure for payments table:

Checking the fraud status:

Advanced problem solving:

Create a procedure to accept the values for the columns in Emp_EH. Handle the error using exception handling concept. Show the message as “Error occurred” in case of anything wrong.