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;

Structure of PL/SQL Block

[<Block Header>]

[DECLARE

<constants>

<variables>

<Cursors>

<user defined exceptions>

]

BEGIN

<PL/SQL Statements>

[Exceptions <exception handlings>]

END;

BLOCK HEADER specifies whether the PL/SQL block is procedure, a function or a package. If no header is specified, the block is said to be an anonymous PL/SQL block.