Live ORACLE

CREATE PACKAGE personnel

AS

  TYPE staff_list IS TABLE OF employees.employee_id%TYPE;

 

  PROCEDURE award_bonuses(empleos_buenos  IN STAFF_LIST);

END personnel;

/


CREATE PACKAGE BODY personnel

AS

  PROCEDURE Award_bonuses

       (empleos_buenos  STAFF_LIST)

  IS

  BEGIN

    FOR i IN empleos_buenos.FIRST.. empleos_buenos.LAST LOOP

      UPDATE employees

      SET    salary = salary + 100

      WHERE  employees.employee_id = Empleos_buenos(i);

    END LOOP;

  END;

END;

/

Declaring a Procedure Parameter as a Nested Table