declare
nodatafound exception;
v_ename emp.ename%type:=’&ename’;
v_empno emp.empno%type;
v_sal emp.sal%type;
n number;
begin
select count(*),empno,sal into n,v_empno,v_sal from emp where ename=v_ename;
if n=0 then
raise nodatafound;
end if;
dbms_output.put_line(v_ename||‘的编号’||v_empno||‘薪水’||v_sal);
exception
when nodatafound then
raise_application_error(-20004,‘该雇员不存在’);
when others then
dbms_output.put_line(‘其他异常’);
end;