User Tools

Site Tools


kurs:uebung_3.2
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;
kurs/uebung_3.2.txt · Last modified: 2014/09/10 21:22 (external edit)