17,377
社区成员
发帖
与我相关
我的任务
分享
--包定义
create or replace package pack_siit is
type t_cur_1 is ref cursor;--定义游标变量
type t_cur_2 is ref cursor;
type t_cur_3 is ref cursor;
type t_cur_4 is ref cursor;
type t_cur_5 is ref cursor;
type t_cur_6 is ref cursor;
procedure GZPC_GZSOFT_GETCODEDATASET
(
cur_1 out t_cur_1,
cur_2 out t_cur_2,
cur_3 out t_cur_3,
cur_4 out t_cur_4,
cur_5 out t_cur_5,
cur_6 out t_cur_6
);
end pack_siit;
--包主体
create or replace package body pack_siit is
procedure GZPC_GZSOFT_GETCODEDATASET
( cur_1 out t_cur_1,
cur_2 out t_cur_2,
cur_3 out t_cur_3,
cur_4 out t_cur_4,
cur_5 out t_cur_5,
cur_6 out t_cur_6)
as
begin
OPEN cur_1 FOR
select * from Basic_Code where substr(CodeId,4,2)='00' and substr(CodeId,2,4)!='0000' and CodeId!='000000';
OPEN cur_2 FOR
select * from Basic_Code where substr(CodeId,4,2)!='00';
OPEN cur_3 FOR
select * from Basic_Code where substr(CodeId,2,4)='0000';
OPEN cur_4 FOR
select * from basic_town;
OPEN cur_5 FOR
select * from basic_village;
OPEN cur_6 FOR
select codeid,(codeid||TownId) as townid,TownName from Basic_Town;
end GZPC_GZSOFT_GETCODEDATASET;
end pack_siit;
DataSet tempds = null;
OracleParameter[] parameters = {
new OracleParameter("cur_1",OracleType.Cursor),
new OracleParameter("cur_2",OracleType.Cursor),
new OracleParameter("cur_3",OracleType.Cursor),
new OracleParameter("cur_4",OracleType.Cursor),
new OracleParameter("cur_5",OracleType.Cursor),
new OracleParameter("cur_6",OracleType.Cursor)};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Direction = ParameterDirection.Output;
parameters[2].Direction = ParameterDirection.Output;
parameters[3].Direction = ParameterDirection.Output;
parameters[4].Direction = ParameterDirection.Output;
parameters[5].Direction = ParameterDirection.Output;
--这是公司里的方法,其实就是写入存储过程名就好了。我用了包,所以是用包名.存储过程名。
tempds = GZSoft.DBUtility.DbHelper.ExecuteDataSetByProc("pack_siit.GZPC_GZSOFT_GETCODEDATASET", parameters);