一、创建包头
create or replace package packtest
is
procedure proceduretest(x number,y number );
end packtest;
create or replace package packtest2
is
function proceduretest(x number,y number ) return number;
end packtest2;
二、创建包体
create or replace package body packtest
is
procedure proceduretest(x number,y number )
is
begin
dbms_output.put_line(x+y);
end;
end packtest;
create or replace package body packtest2
is
function proceduretest(x number,y number ) return number
is
resultv number :=0;
begin
resultv := x+y;
return resultv;
end;
end packtest2;
三、使用
begin
packtest.proceduretest(3,5);
end;
begin
dbms_output.put_line(packtest.proceduretest(3,5));
end;