Packages in PL/SQL

CREATE OR REPLACE PACKAGE BODY emp_actions AS — body
PROCEDURE hire_employee ( ename VARCHAR2, job VARCHAR2, mgr NUMBER, sal NUMBER, comm NUMBER, deptno NUMBER) IS
BEGIN
INSERT INTO emp VALUES (emp_sec.NEXTVAL, ename, job, mgr, SYSDATE, sal, comm, deptno);
COMMIT;
END hire_employee;

PROCEDURE fire_employee (emp_id NUMBER) IS
BEGIN
DELETE FROM emp WHERE empno = emp_id;
COMMIT;
END fire_employee;

END emp_actions;

Related posts:

1. Trigger in PL/SQL
2. Procedure in PL/SQL
3. Structure of PL/SQL Block
4. SQL Statements
5. SQL Functions