Question

Write a procedure called insert_emp which inserts a new employee into f_emps. Pass the employee id, last name, salary, and department id to the procedure as IN parameters. The procedure should call your check_dept function to verify that the passed department id exists in the f_depts table. If it exists, insert the employee. If it does not exist, use DBMS_OUTPUT.PUT_LINE to display a suitable error message. Save your code.

Answer 1

Solution

create or replace procedure insert_emps(p_id f_emps.employee_id%type,p_last f_emps.last_name%type,p_sal f_emps.salary%type,p_dep f_emps.department_id%type)

is

begin

if check_dept(p_dep)=true then

insert into f_emps values(p_id,p_last,p_sal,p_dep);

else

dbms_output.put_line('The department does not exist!');

end if;

end;

---

all the best