C / C++ / MFC

_RecordsetPtr pRS ;
_CommandPtr pcmdStoredProc;

try
{
    hr = pcmdStoredProc.CreateInstance(__uuidof(Command));
    if(FAILED(hr))
        _com_issue_error(hr);

    pcmdStoredProc->ActiveConnection = <Your Connection>

    pcmdStoredProc->CommandType = adCmdStoredProc;
    pcmdStoredProc->CommandText = _bstr_t("<Stored Proc Name>");

    _ParameterPtr param;
    _variant_t vtReturnVal(0L);
    _variant_t vtReturnVal2(0L);

    // example of output parameter
    param = pcmdStoredProc->CreateParameter(_T("<Param 1 Name>"),adInteger,adParamOutput,sizeof(long),vtReturnVal);
    pcmdStoredProc->Parameters->Append(param);

    param = pcmdStoredProc->CreateParameter(_T("<Param 2 Name>"),adInteger,adParamOutput,sizeof(long),vtReturnVal2);
    pcmdStoredProc->Parameters->Append(param);

    // example of input parameter
    param = pcmdStoredProc->CreateParameter(_T("<Param 3 Name>"),adInteger,adParamInput,sizeof(long), _variant_t((long)10));
    pcmdStoredProc->Parameters->Append(param);

    param = pcmdStoredProc->CreateParameter(_T("Param 4 Name>"),adInteger,adParamInput,sizeof(long), _variant_t((long)-1));
    pcmdStoredProc->Parameters->Append(param);

    pRS = pcmdStoredProc->Execute(NULL, NULL, adCmdStoredProc);
}
catch(_com_error& e)
{
    CString sBuff = GetErrorDescription(e);
    AfxMessageBox(sBuff);
    return;
}
catch(...)
{
    AfxMessageBox("Unknown Error Occured");
    return;
}