函数:
SQL> create or replace function fun_emp(f_empno in emp.empno%type)
2 return char
3 as
4 f_ename emp.ename%type;
5 begin
6 select ename into f_ename from emp where empno=f_empno;
7 return(f_ename);
8 end fun_emp;
9 /
Function created
------------------------------------------------------------------------------------
创建
存储过程调用函数:
SQL>
SQL> create or replace procedure pro_emp(var_empno emp.empno%type)
2 as
3 var_ename emp.ename%type;
4 begin
5 var_ename:=fun_emp(var_empno);
6 Dbms_output.put_line('员工编号'||var_empno||'姓名:'||var_ename);
7 Exception
8 when no_data_found then
9 Dbms_output.put_line('对不起!无此员工编号!');
10 end;
11 /
Procedure created
--------------------------------------------------------------------------------------------------
SQL> exec pro_emp('7369');
员工编号7369姓名:SMITH
PL/SQL procedure successfully completed