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;

GOTO statement in PL/SQL

Example:

IF result= ‘fail’

THEN

GOTO fail_msg

END IF;

<<fail_msg>>

Message (“Student is Failed’);