包和存储过程

最近一直在用oracle做开发,由于原来熟悉sqlserver,所以收获还蛮大的,把一些常用写下,好方便查阅.

创建包

create or replace package packageName

as

type curs is ref cursor;

procedure procedureName

(

 invar1 varchar2,

 invar2 varchar2,

 invar3 number,

 invar4 tableName.colName%type,

 invar5 out varchar2    

);

procedure procedureName2

(

 invar1 varchar2,

 cur out curs

    

);

end;

创建存储过程

create or replace package body packageName

as

procedure procedureName

(

 invar1 varchar2,

 invar2 varchar2,

 invar3 number,

 invar4 tableName.colName%type,

 invar5 out varchar2  --顺序不能变

)

is

v_var1 varchar2(50);

v_var2 number(20);

v_var3 tableName%rowtype;

v_var4 varchar(50):='';

begin

--处理语句...

--结束之前要给输出变量赋值

invar5:= '输出';

end procedureName;

procedure procedureName2

(

 invar1 varchar2,

 cur out curs

    

)

is

begin

open cur is select * from tableName;

end procedureName2;