create or replace procedure query_sal(eno employee.employeeno%type,name out employee.employeename%type,salary in out employee.sal%type) is v_sal number; begin select employeename ,sal into name,v_sal from employee where employeeno = eno; salary := salary + v_sal; exception when no_data_found then raise_application_error(-20000,'该雇员不存在'); end query_sal; --执行存储过程： declare name employee.employeename%type; salary employee.sal%type; begin query_sal('1990-003',name,salary); dbms_output.put_line('雇员：'||name||'的薪水为:'||salary); end; 只能输出name,为什么得不到salary的值？请好心人帮个忙，帮我检查下！hr下的employees表？ employee表：sal,employeename,employeeno三个属性名 salary := salary + v_sal; 在这里先输出下salary 的值 为什么要先赋予一个值呢，我employeename没赋值同样可以输出但salary没赋值能输出呢！ name相当于直接赋值， 但salary为null，导致salary + v_sal也为null salary := salary + v_sal;
