-- Using More Package Concepts


-- 1. Ошибка, когда в теле функции происходит модификация данных таблицы

CREATE OR REPLACE PACKAGE taxes_pkg7 IS
  FUNCTION tax (VALUE IN NUMBER) RETURN NUMBER;
END taxes_pkg7;

CREATE OR REPLACE PACKAGE BODY taxes_pkg7 IS
  FUNCTION tax (VALUE IN NUMBER) RETURN NUMBER IS
    rate NUMBER := 0.08;
  BEGIN
    INSERT INTO regions VALUES (5, 'Perm');
    RETURN (VALUE * rate);
  END tax;
END taxes_pkg7;


SELECT taxes_pkg7.tax(salary), salary, last_name
FROM   employees;