Refer to the exhibit.

```
-- Creating a PL/SQL function
CREATE OR REPLACE FUNCTION get_emp_name (p_emp_id NUMBER) RETURN VARCHAR2 IS
    v_name employees.last_name%TYPE;
BEGIN
    SELECT last_name INTO v_name FROM employees WHERE employee_id = p_emp_id;
    RETURN v_name;
END;
```