Oracle_存储过程

create or replace  procedure pro_query_emp
(v_no in emp.empno%type)--在这个定义的时候标明 in
as
v_sal emp.empno%type;
begin
select sal into v_sal from emp where empno=v_no;
dbms_output.put_line(‘薪水为：‘||v_sal);
exception 
when no_data_fount then
dbms_output.put_line(‘该员工不存在！‘);
end;

create or relpace procedure pro_querysal_emp
(param_empno number,param_sal out varchar2)--定义out参数保存雇员薪水
as
begin
select sal into param_sal from emp where empno=param_empno;
exception
when no_data_found then
dbms_output.put_line(‘该员工不存在！‘);
end;

--调用out参数的过程
declare
v_empno EMP.empno%type;--定义变量存储员工的编号
v_sal emp.sal%type;--定义变量存储返回值
begin 
v_empno:=&no;
pro_querysal_emp(v_empno,v_sal);
dbms_output.put_line(‘薪水是：‘||v_sal);
end;

 create or  replace procedure proc_testinout

(param_num in out number)

as 

begin

param_number:=param_num*2;

end;