13PL_SQL过程之错误处理即捕获异常

declare
  v_temp number(4);
begin
  select empno into v_temp from emp where deptno=10;
  exception
    when too_many_rows then
      dbms_output.put_line('太多记录了');
    when others then
      dbms_output.put_line('error!');
end;






declare
  v_temp number(4);
begin
  select empno into v_temp from emp where empno=2222;
  exception
    when no_data_found then
      dbms_output.put_line('没有数据');
end;