need help with parts a, b , and c

This question assumes the following relational schema Employee (EmpID, Lname, Fname, DOB, HireDate, Position, Salary, Dept) Primary Key: EmpID Foreign key: Dept refers to DeptID in Department Deptartment (DeptID, DeptName, FacultyID) Primary Key: DeptID You have been given the following stored PL/SQL procedure named SEARCH EMP: CREATE OR REPLACE PROCEDURE SEARCH_EMP (I_last IN Varchar2, 0 EmpID OUT Number) AS BEGIN SELECT EmpID INTO 0 EmpIID FROM Empployee WHERE Lname = 1-last; END SEARCH_ EMP; (a) 2 marks) Name the two types of parameters that have been used in the declaration of the procedure SEARCH EMP. Describe both these types. Include in your discussion one characteristic feature for each type (b) (2 marks) Discuss the error conditions that you may come across as a result of the ex ecution of the procedure SEARCH EMP. Add an appropriate exception handling section to the procedure in order to handle such errors (c) (2 marks) Create a PL/SQL procedure that takes an employee's position such as Manager as input, and prints the details of all staff's holding that position includ ing their ID, hire date and the name of the department that they work in. You may use the following procedure template: CREATE OR REPLACE PROCEDURE dept_staff (Iposition In Department position type) AS CURSOR c1 is BEGIN END dept_staff