Oracle的package用法测试

oralce的package由 包头和包体构成；

包头声明要做的事情，包体做具体的实现，话不多说直接上代码：

create or replace package pkg_firste_test as 

procedure p_update_lable(v_id in number);

function addid(x in number,y in number) return number ;

end ;




-- ------------------------------------------------------------


create or replace package body pkg_firste_test is 



-- 修改输入的参数
procedure p_update_lable (v_id in number)

as 

begin 

update sub_user set lable='unknow' where id=v_id;
commit;

end p_update_lable;



-- 函数的编写

function addid(x in number,y in number) return number 

is 

mysum number :=0;

begin 

mysum:=x+y;

return mysum;
end addid;

end pkg_firste_test;

调用方式：

call pkg_firste_test.p_update_lable(2);


select  pkg_firste_test.addid(1,4) from dual;