PROCEDURE P_RAISE_EXCEPTION ( 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; -- commit; EXCEPTION WHEN zuviele_personen THEN rollback; dbms_output.put_line('zuviel Personen'); raise_application_error(-20001, 'ganz furchtbar', TRUE); when others then rollback; END; -- Procedure