Live ORACLE

CREATE OR REPLACE PACKAGE emp_actions

AS -- package specification



  FUNCTION raise_salary(emp_id  NUMBER,sal_raise  NUMBER) RETURN NUMBER;

END emp_actions;

/


CREATE OR REPLACE PACKAGE BODY emp_actions

AS -- package body



  -- code for function raise_salary

  FUNCTION Raise_salary

       (emp_id     NUMBER,

        sal_raise  NUMBER)

  RETURN NUMBER

  IS

    PRAGMA AUTONOMOUS_TRANSACTION;

    new_sal  NUMBER(8,2);

  BEGIN

    UPDATE employees

    SET    salary = salary

                      + sal_raise

    WHERE  employee_id = emp_id;

    COMMIT;

    SELECT salary

    INTO   new_sal

    FROM   employees

    WHERE  employee_id = emp_id;

    RETURN new_sal;

  END raise_salary;

END emp_actions;

/

Declaring an Autonomous Function in a Package