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, mgrhiredate, sal, comm, de[tno);..END;