oracle怎样执行包,oracle中包的创建和调用

包用于在逻辑上的组合过程和函数，它由包规范和包体两部分组成。

1.创建包规范

create package sp_package is  procedure update_sal(name varchar2,newsal number);

function annual_income(name varchar2) return number;

end;

2.创建包体

create or replace package body sp_package is

procedure update_sal(name varchar2,newsal number)

is

begin

update emp set sal=newsal where ename=name;

end;

function annual_income(name varchar2)

return number is

annual_salary number;

begin

select sal*12+nvl(comm,0)*12 into  annual_salary from emp where ename=name;

return annual_salary;

end;

end;

调用

exec sp_package.update_sal('SCOTT',2600);