最近在写OCI获取数据的功能,OCI批量获取数据遇到了一些问题。
OCIStmt* pStmt = NULL;
OCIStmt* pCur = NULL;
OCIHandleAlloc(m_pEnvHandle,(dvoid**)&pStmt,OCI_HTYPE_STMT,0,NULL);
OCIStmtPrepare(pStmt,m_pErrHandle,(const OraText *)sSql.c_str(),sSql.length(),OCI_NTV_SYNTAX,OCI_DEFAULT);
OCIHandleAlloc(m_pEnvHandle, (void **)(&pCur), OCI_HTYPE_STMT, 0, NULL);
OCIBindByPos(pStmt,&pBind, m_pErrHandle, outOrder, &pCur, 0,SQLT_RSET,
pIndicator, 0,NULL, 0,0,OCI_DEFAULT);
OCIStmtExecute(m_pSvcHandle, pStmt, m_pErrHandle, 1, 0, NULL, NULL,
OCI_COMMI