/////// 存储过程 ///////////////////////////
PROCEDURE J_STCF
(begin_accnbr in number, --开始号码
end_accnbr in number, --结束号码
v_resultset Out TCursor) --输出的结果集合)
is
begin
Open v_resultset for
select area_code, access_num, je from urge_order;
end;
///////////////////////////////////////////////vc代码_bstr_t bstrProc =( L"J_STCF" ); //Stored procedure name_CommandPtr pCmd; // command object pointer
pCmd.CreateInstance( __uuidof( Command ) ); // creating command object
ASSERT(pCmd != NULL);
int lStartSjhm,lEndSjhm;
char szTmp[20];
lStartSjhm = 100;
lEndSjhm = 200;pCmd->ActiveConnection = CAdoData.pDBConn; // giving the connection handle
pCmd->CommandText = _bstr_t( bstrProc ); // passing the stored procedue
pCmd->CommandType = adCmdStoredProc; // typepParam1 = pCmd->CreateParameter(_bstr_t("begin_accnbr"), adInteger, adParamInput, 4, lStartSjhm);
pCmd->Parameters->Append(pParam1); pParam2 = pCmd->CreateParameter(_bstr_t("end_accnbr"), adInteger, adParamInput, 4, lEndSjhm);
pCmd->Parameters->Append(pParam2); 想把TCursor的输出结果集合得到,写到这里的时候不会写了,那位大侠能帮忙,告诉我怎么写吗? 急
PROCEDURE J_STCF
(begin_accnbr in number, --开始号码
end_accnbr in number, --结束号码
v_resultset Out TCursor) --输出的结果集合)
is
begin
Open v_resultset for
select area_code, access_num, je from urge_order;
end;
///////////////////////////////////////////////vc代码_bstr_t bstrProc =( L"J_STCF" ); //Stored procedure name_CommandPtr pCmd; // command object pointer
pCmd.CreateInstance( __uuidof( Command ) ); // creating command object
ASSERT(pCmd != NULL);
int lStartSjhm,lEndSjhm;
char szTmp[20];
lStartSjhm = 100;
lEndSjhm = 200;pCmd->ActiveConnection = CAdoData.pDBConn; // giving the connection handle
pCmd->CommandText = _bstr_t( bstrProc ); // passing the stored procedue
pCmd->CommandType = adCmdStoredProc; // typepParam1 = pCmd->CreateParameter(_bstr_t("begin_accnbr"), adInteger, adParamInput, 4, lStartSjhm);
pCmd->Parameters->Append(pParam1); pParam2 = pCmd->CreateParameter(_bstr_t("end_accnbr"), adInteger, adParamInput, 4, lEndSjhm);
pCmd->Parameters->Append(pParam2); 想把TCursor的输出结果集合得到,写到这里的时候不会写了,那位大侠能帮忙,告诉我怎么写吗? 急
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货