oracle包的定义案例

create or replace package DotNet is -- Author : ADMINISTRATOR -- Created : 2011-1-20 15:47:57 -- Purpose : -- Public type declarations type type_cur is REF CURSOR; --卡蚩罂标 -- Public constant declarations --<ConstantName> constant <Datatype> := <Value>; -- Public variable declarations --<VariableName> <Datatype>; -- Public function and procedure declarations --function <FunctionName>(<Parameter> <Datatype>) return <Datatype>; PROCEDURE DotNetPagination( Pindex in number, Psql in varchar2, Psize in number, Pcount out number, v_cur out type_cur ); PROCEDURE DotNetPageRecordsCount( Psqlcount in varchar2, Prcount out number ); FUNCTION getBank(codeno IN varchar2) RETURN varchar2; end create or replace package DotNet is -- Author : ADMINISTRATOR -- Created : 2011-1-20 15:47:57 -- Purpose : -- Public type declarations type type_cur is REF CURSOR; --游标 -- Public constant declarations --<ConstantName> constant <Datatype> := <Value>; -- Public variable declarations --<VariableName> <Datatype>; -- Public function and procedure declarations --function <FunctionName>(<Parameter> <Datatype>) return <Datatype>; PROCEDURE DotNetPagination( Pindex in number, Psql in varchar2, Psize in number, Pcount out number, v_cur out type_cur ); PROCEDURE DotNetPageRecordsCount( Psqlcount in varchar2, Prcount out number ); FUNCTION getBank(codeno IN varchar2) RETURN varchar2; end DotNet;