CREATE OR REPLACE PROCEDURE proc(d_name departments.department_name%TYPE) IS
  invalid_name EXCEPTION;
BEGIN
  UPDATE employees
  SET salary = salary * 1.1
  WHERE department_id IN (SELECT department_id
                          FROM departments
                          WHERE department_name = d_name);

  IF SQL%ROWCOUNT = 0 THEN
    RAISE invalid_name;
  ELSE
    DBMS_OUTPUT.PUT_LINE('Podniesiono pensje ' || SQL%ROWCOUNT || ' pracownikom');
  END IF;
EXCEPTION
  WHEN invalid_name THEN
    DBMS_OUTPUT.PUT_LINE('Nie ma dzialu o takiej nazwie!');
END;
/

--sprawdzenie:
SELECT e.last_name, e.salary
FROM employees e JOIN departments d ON e.department_id = d.department_id
WHERE d.department_name = 'Marketing';

--wywolanie:
BEGIN
  proc('Marketing');
END;
/

--wywolanie bledne:
BEGIN
  proc('AAAAAAAAAA');
END;
/