Learning Goal: I’m working on a mysql question and need an explanation and answe

Learning Goal: I’m working on a mysql question and need an explanation and answer to help me learn.For this assignment, create a stored procedure using Oracle that will update the salary of an employee in a sample “emp” table. This table probably exists in your database already but if it does not, there is code to create it in the directory. Make sure you use proper transaction control and error checking. I need to see the code for the procedure and see the execution of the procedure with the results. 1. Open an Oracle SQL*Plus (or any other Oracle tool of your choice) session as shown below. Log in using your Oracle account. Examine the data in the emp table. It should look similar to the screen below (it does not have to be exactly the same) Below is a sample to get you started. Create or Replace Procedure update_emp (emp_id int, new_sal number) IS –USED FOR ERROR CHECKING v_ErrorCode number; v_ErrorMsg Varchar2(200); v_CurrentUser Varchar2(100); BEGIN . . . Exception When OTHERS THEN END update_emp; / Once your procedure is completed, compile it and test it by updating an employee with a new salary. Please send the code and an example of the procedure running.