HR

Basic Index   Expanded Index

Stored Procedure:ADD_JOB_HISTORY

ParameterTypeIn/Out
P_EMP_IDNUMBER (6)IN
P_START_DATEDATEIN
P_END_DATEDATEIN
P_JOB_IDVARCHAR2 (MAX)IN
P_DEPARTMENT_IDNUMBER (4)IN


PROCEDURE add_job_history
( p_emp_id job_history.employee_id%type
, p_start_date job_history.start_date%type
, p_end_date job_history.end_date%type
, p_job_id job_history.job_id%type
, p_department_id job_history.department_id%type
)
IS
BEGIN
INSERT INTO job_history (employee_id, start_date, end_date,
job_id, department_id)
VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
END add_job_history;