Hello,
I wanted to take the following sql and put it in a plsql precedure so that a user can just execute that procedure when ever they wanted to do the following operation.


spool delete_one_employee
delete from HRW_HEALTH_PLAN_DEPENDENTS where
health_plan_key in
(select health_plan_key from hrw_dependents where employee_id = '&&emp_id');

delete from HRW_INSURANCE_BENEFICIARIES where
insurance_key in
(select insurance_key from hrw_insurances where employee_id = '&&emp_id');

delete from HRW_INSURANCE_OFFERS where employee_id = '&&emp_id';

spool off
thanks
Jigar