oracle package
create?or?replace?package?PACK_INTERFACE?
is
??
??type?SN_CURSOR?
is
?REF?CURSOR;
??PROCEDURE?P_SELECT_SN?(RE_SN??OUT?SN_CURSOR);???
end?PACK_INTERFACE;
create?or?replace?package?body?PACK_INTERFACE?
is
???PROCEDURE?P_SELECT_SN?(RE_SN?OUT?SN_CURSOR)
???IS
?????p_SN_CURSOR?SN_CURSOR;
???BEGIN
?????OPEN?P_SN_CURSOR?FOR
????????select?
*
?from?rmes.r_wip_tracking_t?t
????????WHERE?GROUP_ID?
=
?
0
?AND?IN_LINE_TIME?
>
?TRUNC(SYSDATE);
?????RE_SN:
=
P_SN_CURSOR;
???END;
end?PACK_INTERFACE;
C#
OracleParameter[]?param?
=
?
new
?OracleParameter[
1
];????????????????????????
????????????param[
0
]?
=
?
new
?OracleParameter(
"
RE_SN
"
,OracleType.Cursor);
????????????param[
0
].Direction?
=
?ParameterDirection.Output;
????????????
????????????????????????????
????????????DataTable?dt?
=
?Query.RunProcedure(
"
PACK_INTERFACE.P_SELECT_SN
"
,param,
"
mes
"
);
????????????DataGrid1.DataSource?
=
?dt;
????????????DataGrid1.DataBind();
create?or?replace?package?PACK_INTERFACE?
is
??
??type?SN_CURSOR?
is
?REF?CURSOR;
??PROCEDURE?P_SELECT_SN?(RE_SN??OUT?SN_CURSOR);???
end?PACK_INTERFACE;
create?or?replace?package?body?PACK_INTERFACE?
is
???PROCEDURE?P_SELECT_SN?(RE_SN?OUT?SN_CURSOR)
???IS
?????p_SN_CURSOR?SN_CURSOR;
???BEGIN
?????OPEN?P_SN_CURSOR?FOR
????????select?
*
?from?rmes.r_wip_tracking_t?t
????????WHERE?GROUP_ID?
=
?
0
?AND?IN_LINE_TIME?
>
?TRUNC(SYSDATE);
?????RE_SN:
=
P_SN_CURSOR;
???END;
end?PACK_INTERFACE;
OracleParameter[]?param?
=
?
new
?OracleParameter[
1
];????????????????????????
????????????param[
0
]?
=
?
new
?OracleParameter(
"
RE_SN
"
,OracleType.Cursor);
????????????param[
0
].Direction?
=
?ParameterDirection.Output;
????????????
????????????????????????????
????????????DataTable?dt?
=
?Query.RunProcedure(
"
PACK_INTERFACE.P_SELECT_SN
"
,param,
"
mes
"
);
????????????DataGrid1.DataSource?
=
?dt;
????????????DataGrid1.DataBind();
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯(lián)系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機(jī)微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
