dokuwiki

PROCEDURE P_ERROR
   ( v_last_name IN employees.last_name%TYPE)
   IS
  v_emp_id number(30);
BEGIN
  select employee_id into v_emp_id
    from employees
    where last_name=v_last_name;
    
    dbms_output.put_line(v_emp_id);
EXCEPTION
    WHEN No_Data_found THEN
      dbms_output.put_line('Keine Daten gefunden');
    WHEN Too_many_Rows THEN
      dbms_output.put_line('Zu viele Daten gefunden');
    WHEN others THEN
      dbms_output.put_line('irgendein Fehler');

END;