PROCEDURE P_RAISE_EXEPTION
( v_last_name IN varchar2,
v_salary in Number)
IS
zuviele_personen exception;
BEGIN
update employees
set salary = v_salary
where last_name=v_last_name;
if SQL%ROWCOUNT>1 THEN
raise zuviele_personen;
end if;
EXCEPTION
WHEN zuviele_personen THEN
rollback ;
dbms_output.put_line('zuviele Personen');
raise_application_error(-20001, 'ganz furchtbar', TRUE);
END;