This illustration shows the HIRE_EMP Procedure.

Procedure HIRE_EMP (name VARCHAR2, job VARCHAR2,
mgr NUMBER, hiredate DATE, sal NUMBER,
comm NUMBER, deptno NUMBER)

BEGIN
.
.
INSERT INTO emp VALUES
(emp_sequence.NEXTVAL, name, job, mgr
hiredate, sal, comm, de[tno);
.
.
END;