no_exception_err_ok.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 16 行

create or replace procedure get_name(p_id varchar2)
is 
  v_name varchar2(20);

begin
  select name into v_name  from sm_emp where empid = p_id;

  dbms_output.put_line('name :' || v_name);
EXCEPTION
		WHEN NO_DATA_FOUND THEN
			DBMS_OUTPUT.PUT_LINE('NO EMPLOYEE ' ||p_id );
		WHEN TOO_MANY_ROWS THEN
			DBMS_OUTPUT.PUT_LINE('TOO MANY  ' || p_id);
		WHEN OTHERS  THEN
			DBMS_OUTPUT.PUT_LINE('ERROR!');	
end;