create or replace procedure jx (gh in emp.empno%type,xm out emp.ename%type,gz out emp.sal%type) as v_gw emp.job%type; begin select job into v_gw from emp where empno=gh; case when v_gw='CLERK' then update emp set sal=nvl(sal,0)+1 where empno=gh; case when v_gw='ANALYST' then update emp set sal=nvl(sal,0)+2 where empno=gh; case when v_gw='SALESMAN' then update emp set sal=nvl(sal,0)+3 where empno=gh; case when v_gw='MANAGER' then update emp set sal=nvl(sal,0)+4 where empno=gh;else update emp set sal=nvl(sal,0)+5 where empno=gh; end case; select ename,sal into xm,gz from emp where empno=gh; exception when no_data_found then dbms_output.put_line('查无此人!'); end;