create function sp_fun2(spname varchar2) return
number is yearSal number(7,2);
begin
select sal*12+nvl(comm,0)*12 into yearSal from emp where ename=sp
return yearSal;
end;
var resultValue number;
call sp_fun2('SCOTT') into:resultValue;
print resultValue;
在java程序中调用该函数
select sp_fun2('SCOTT') from dual;
可以通过rs.getInt(1)得到返回结果。