# Exception Handling with CONTINUE Handler

CREATE TABLE Employee 
(
     EmpID INT PRIMARY KEY,
     EmpName VARCHAR(50),
     EmailAddress VARCHAR(50)    
);


DELIMITER //
CREATE PROCEDURE InsertEmployeeDetails
(
     InputEmpID INTEGER,
     InputEmpName VARCHAR(50),
     InputEmailAddress VARCHAR(50)    
)

BEGIN 
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'Error occured';
	INSERT INTO Employee (EmpID, EmpName, EmailAddress)
	VALUES (InputEmpID, InputEmpName, InputEmailAddress);    
 
 SELECT * FROM Employee;
 
END // 


CALL InsertEmployeeDetails (1,'Anvesh','anvesh@gmail.com');
CALL InsertEmployeeDetails (1,'Roy','Roy@gmail.com');