AMPS:Oracle数据库操作模块源码解读

最新推荐文章于 2021-04-13 00:34:22 发布
最新推荐文章于 2021-04-13 00:34:22 发布
阅读量3.3k 收藏 1
点赞数 1
分类专栏： C/C++ ORACLE 消息中间件 AMPS源码解读
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/dyx1024/article/details/8543688
版权

  本节看看AMPS中对Oracle数据库进行操作的方法，使用的是Oracle的C访问接口OCI，关于OCI各函数的中文说明可参考这篇文章http://www.cnblogs.com/joeblackzqq/archive/2011/04/24/2026461.html

 下面看看AMPS中Oracle操作各函数实现:

 AMPS_Oracle.h

#ifndef __HEADER_AMPS_DB_ORACLE_H
#define __HEADER_AMPS_DB_ORACLE_H

#ifdef __cplusplus
extern "C" {
#endif

#include "AMPS_Defines.h"
#include "AMPS_LinkList.h"
#include "AMPS_MemMgt.h"
#include "AMPS_EventSystem.h"
#include "AMPS_Core.h"
#include "AMPS_API.h"

typedef struct _OracleContext					t_OracleContext;
typedef struct _OracleColumnData				t_OracleColumnData; 

#define ORACLE_MAX_SELECT_COLUMN_LIST_SIZE		1024
#define ORACLE_MAX_DB_PATH_SIZE					2048
#define ORACLE_SELECT_COUNT_QUERY_SIZE			4096

struct _OracleColumnData 
{
	unsigned char*	puchValue;
	signed int		nValueLen;
};

#ifdef WIN32
struct _OracleContext
{
	OCIEnv*					hOCIEnv;
	OCIError*				hOCIError;
	OCIServer*				hOCIServer;
	OCISvcCtx*				hOCISvcCtx;
	OCISession*				hOCISession;

	t_OracleColumnData		poOracleColumnData[ORACLE_MAX_SELECT_COLUMN_LIST_SIZE];

	unsigned char			puchDBPath[ORACLE_MAX_DB_PATH_SIZE];

	unsigned char			puchSelectCountQuery[ORACLE_SELECT_COUNT_QUERY_SIZE];
};
#endif

int Oracle_Init(void* r_pvAMPSContext, void* r_pvBDEngineContext);
void Oracle_Cleanup(void* r_pvAMPSContext, void* r_pvBDEngineContext);
int Oracle_Query(void* r_pvAMPSContext, void* r_pvBDEngineContext, const char* r_pcchQueryStatement, unsigned long r_ulLengthOfQuery, t_AMPSDBEngineResult* r_poAMPSDBEngineResult);
void Oracle_FreeResults(void* r_pvAMPSContext, void* r_pvBDEngineContext, t_AMPSDBEngineResult* r_poAMPSDBEngineResult);

void Oracle_CheckError(void* r_pvAMPSContext, void* r_pvBDEngineContext, signed int r_nStatus);
int Oracle_GetNumberOfRecords(void* r_pvAMPSContext, void* r_pvBDEngineContext, const char* r_pcchQueryStatement, unsigned long r_ulLengthOfQuery);

#ifdef __cplusplus
}
#endif

#endif //__HEADER_AMPS_DB_ORACLE_H

AMPS_Oracle.c 

#include "AMPS_DBEngine.h"
#include "AMPS_Oracle.h"

/*****************************************************************
函数名称: Oracle_Init
功能描述: Oracle数据库访问初始化函数
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文

出参:
      
返回值:
    int

*****************************************************************/
int Oracle_Init(void* r_pvAMPSContext, void* r_pvBDEngineContext)
{
#ifdef WIN32
	signed int nReturnCode = 0;
	t_OracleContext* poOracleContext = NULL;
	t_BDEngineContext* poBDEngineContext = r_pvBDEngineContext;

	//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_INFO, "Entering.\n");

	poOracleContext = (t_OracleContext*)AMPS_InternalMalloc(sizeof(t_OracleContext));
	if(NULL == poOracleContext)
	{
		TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "AMPS_InternalMalloc failed for poOracleContext.\n");
		return AMPS_ERROR_FAILURE;
	}

	poBDEngineContext->poDBHandle = poOracleContext;

    /*创建OCI环境*/
	//allocate an environment handle
	nReturnCode = OCIEnvCreate((OCIEnv**)&poOracleContext->hOCIEnv, OCI_DEFAULT, NULL, NULL, NULL, NULL, 0, NULL);
	if(OCI_SUCCESS != nReturnCode) 
	{
		printf("OCIEnvCreate failed with nReturnCode = %d.\n", nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*分配错误句柄OCIError */
	//allocate an error handle
	nReturnCode = OCIHandleAlloc((void*)poOracleContext->hOCIEnv, (void**)&poOracleContext->hOCIError, OCI_HTYPE_ERROR, 0, NULL);
	if(OCI_SUCCESS != nReturnCode) 
	{
		printf("OCIHandleAlloc failed with nReturnCode = %d.\n", nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*分配服务器句柄OCIServer*/
	//allocate a server handle
	nReturnCode = OCIHandleAlloc((void*)poOracleContext->hOCIEnv, (void**)&poOracleContext->hOCIServer, OCI_HTYPE_SERVER, 0, NULL);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

	//"//192.168.0.4:1521/orcl"
	sprintf(poOracleContext->puchDBPath, "//%s:1521/%s", poBDEngineContext->pchHostName, poBDEngineContext->pchDataBaseName);

    /*创建多用户连接*/
	//create a server context
	nReturnCode = OCIServerAttach(poOracleContext->hOCIServer, poOracleContext->hOCIError, (unsigned char*)poOracleContext->puchDBPath, strlen(poOracleContext->puchDBPath), 0);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}	

    /*分配服务器环境句柄*/
	//allocate a service handle
	nReturnCode = OCIHandleAlloc((void*)poOracleContext->hOCIEnv, (void**)&poOracleContext->hOCISvcCtx, OCI_HTYPE_SVCCTX, 0, NULL);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*设置句柄OCI_HTYPE_SVCCTX的属性*/
    //set the server attribute in the service context handle
	nReturnCode = OCIAttrSet((void*)poOracleContext->hOCISvcCtx, OCI_HTYPE_SVCCTX, (void*)poOracleContext->hOCIServer, 0, OCI_ATTR_SERVER, (OCIError*)poOracleContext->hOCIError);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*分配用户会话句柄*/
	//allocate a user session handle
	nReturnCode = OCIHandleAlloc((void*)poOracleContext->hOCIEnv, (void**)&poOracleContext->hOCISession, OCI_HTYPE_SESSION, 0, NULL);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}
    
    /*设置数据库访问用户名*/
	//set username and password attributes in user session handle
	nReturnCode = OCIAttrSet((void*)poOracleContext->hOCISession, OCI_HTYPE_SESSION, (void*)poBDEngineContext->pchUserName, strlen((char*)poBDEngineContext->pchUserName), OCI_ATTR_USERNAME, poOracleContext->hOCIError);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}
    
    /*设置数据库访问密码*/
	nReturnCode = OCIAttrSet((void*)poOracleContext->hOCISession, OCI_HTYPE_SESSION, (void*)poBDEngineContext->pchPassword, strlen((char*)poBDEngineContext->pchPassword), OCI_ATTR_PASSWORD, poOracleContext->hOCIError);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*认证用户并建立连接*/
	//start the session
	nReturnCode = OCISessionBegin (poOracleContext->hOCISvcCtx, poOracleContext->hOCIError, poOracleContext->hOCISession, OCI_CRED_RDBMS, OCI_DEFAULT);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*设置用户属性*/
	//set the user session attribute in the service context handle
	nReturnCode = OCIAttrSet(poOracleContext->hOCISvcCtx, OCI_HTYPE_SVCCTX, poOracleContext->hOCISession, sizeof(OCISession*), OCI_ATTR_SESSION, poOracleContext->hOCIError);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}
	return AMPS_SUCCESS;
#else
	return AMPS_ERROR_FAILURE;
#endif
}

/*****************************************************************
函数名称: Oracle_Cleanup
功能描述: Oracle数据库访问销毁函数
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文

出参:
      
返回值:
    int

*****************************************************************/
void Oracle_Cleanup(void* r_pvAMPSContext, void* r_pvBDEngineContext)
{
#ifdef WIN32
	t_BDEngineContext* poBDEngineContext = r_pvBDEngineContext;
	t_OracleContext* poOracleContext = poBDEngineContext->poDBHandle;

	if(poOracleContext->hOCIEnv)
	{
		(void)OCIHandleFree((void*)poOracleContext->hOCIEnv, OCI_HTYPE_ENV);
	}
#endif
}

/*****************************************************************
函数名称: Oracle_GetNumberOfRecords
功能描述: 获取记录条数
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文
      const char* r_pcchQueryStatement SQL查询语句
      unsigned long r_ulLengthOfQuery SQL查询语句长度

出参:
      
返回值:
    int

*****************************************************************/
int Oracle_GetNumberOfRecords(void* r_pvAMPSContext, void* r_pvBDEngineContext, const char* r_pcchQueryStatement, unsigned long r_ulLengthOfQuery)
{
#ifdef WIN32
	t_BDEngineContext* poBDEngineContext = r_pvBDEngineContext;
	t_OracleContext* poOracleContext = poBDEngineContext->poDBHandle;
	signed int nReturnCode = OCI_ERROR;
	OCIStmt* hOCIStmtSelectCount = NULL;
	unsigned long ulLengthOfSelectCountQuery = 0;
	const char* pchPosition = NULL;

	OCIDefine* hOCIDefine = NULL;
	OCIParam* hOCIParam = NULL;
	unsigned int unSize = 0;
	unsigned int unNoOfColumns = 0;
	unsigned int unColumnCount = 0;
	unsigned int unRowCount = 0;
	t_AMPSDBEngineResult oAMPSDBEngineResult;

    /*查看SQL语句中是否有FROM关键字*/
	pchPosition = SAPI_StrCaseStr(r_pcchQueryStatement, "FROM");
	if(NULL == pchPosition)
	{
		return AMPS_ERROR_FAILURE;
	}

	memset(poOracleContext->puchSelectCountQuery, 0, ORACLE_SELECT_COUNT_QUERY_SIZE);
	sprintf(poOracleContext->puchSelectCountQuery, "Select Count(*) %s", pchPosition);

    /*创建语句句柄*/
	//allocate statement handle
	nReturnCode = OCIHandleAlloc(poOracleContext->hOCIEnv, (void**)&hOCIStmtSelectCount, OCI_HTYPE_STMT, 0, NULL);
	if(nReturnCode == OCI_SUCCESS)
	{
		ulLengthOfSelectCountQuery = strlen(poOracleContext->puchSelectCountQuery);

        /*准备SQL语句*/
        nReturnCode = OCIStmtPrepare(hOCIStmtSelectCount, poOracleContext->hOCIError, (unsigned char*)poOracleContext->puchSelectCountQuery, ulLengthOfSelectCountQuery, OCI_NTV_SYNTAX, OCI_DEFAULT);
		if(nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}
	}

	memset(poOracleContext->poOracleColumnData, 0, (sizeof(t_OracleColumnData) * ORACLE_MAX_SELECT_COLUMN_LIST_SIZE));

    /*执行SQL语句*/
	nReturnCode = OCIStmtExecute(poOracleContext->hOCISvcCtx, hOCIStmtSelectCount, poOracleContext->hOCIError, 0, 0, NULL, NULL, OCI_DEFAULT);
	if(nReturnCode != OCI_SUCCESS)
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*获取属性*/
	nReturnCode = OCIAttrGet(hOCIStmtSelectCount, OCI_HTYPE_STMT, &unNoOfColumns, NULL, OCI_ATTR_PARAM_COUNT, poOracleContext->hOCIError);
	if(nReturnCode != OCI_SUCCESS)
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

	//get next column info
	for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
	{
		nReturnCode = OCIParamGet(hOCIStmtSelectCount, OCI_HTYPE_STMT, poOracleContext->hOCIError, (void**)&hOCIParam, unColumnCount + 1);
		if(nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}

		// maximum data size in bytes
		unSize = 0;
		nReturnCode = OCIAttrGet(hOCIParam, OCI_DTYPE_PARAM, &unSize, NULL, OCI_ATTR_DATA_SIZE, poOracleContext->hOCIError);
		if(nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}

		poOracleContext->poOracleColumnData[unColumnCount].puchValue = AMPS_InternalMalloc(unSize + 1);
		poOracleContext->poOracleColumnData[unColumnCount].nValueLen = unSize;
		memset(poOracleContext->poOracleColumnData[unColumnCount].puchValue, 0, poOracleContext->poOracleColumnData[unColumnCount].nValueLen);

        /*定义输出变量*/
		nReturnCode = OCIDefineByPos(hOCIStmtSelectCount, &hOCIDefine, poOracleContext->hOCIError, unColumnCount + 1, poOracleContext->poOracleColumnData[unColumnCount].puchValue, unSize, STRING_TYPE, NULL, NULL, NULL, OCI_DEFAULT);
		if(nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}
	}

	oAMPSDBEngineResult.ulNumberOfColumns = unNoOfColumns;
	oAMPSDBEngineResult.ulNumberOfRows = 100;
	oAMPSDBEngineResult.ulNumberOfResults = oAMPSDBEngineResult.ulNumberOfRows;

	if (0 < oAMPSDBEngineResult.ulNumberOfRows) 
	{
		oAMPSDBEngineResult.ppoAMPSDBEngineTable = (t_AMPSDBEngineTable**)AMPS_InternalMalloc(sizeof(t_AMPSDBEngineTable*) * oAMPSDBEngineResult.ulNumberOfRows);
		if(NULL == oAMPSDBEngineResult.ppoAMPSDBEngineTable)
		{
			//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "AMPS_InternalMalloc failed for r_poBDEngineResult->ppoAMPSDBEngineTable.\n");
			return AMPS_ERROR_FAILURE;
		}

		//printf("\n\n r_poBDEngineResult->ulNumberOfRows is %ld  r_poBDEngineResult->ulNumberOfColumns %ld and r_poBDEngineResult->ppoAMPSDBEngineTable %p\n\n",r_poBDEngineResult->ulNumberOfRows, r_poBDEngineResult->ulNumberOfColumns, r_poBDEngineResult->ppoAMPSDBEngineTable);

		for(unRowCount = 0; unRowCount < oAMPSDBEngineResult.ulNumberOfRows; unRowCount++)
		{
            /*逐行提取结果*/
			nReturnCode = OCIStmtFetch(hOCIStmtSelectCount, poOracleContext->hOCIError, 1, OCI_FETCH_NEXT, OCI_DEFAULT);
			if(nReturnCode != OCI_SUCCESS)
			{
				Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
				break;
			}

			oAMPSDBEngineResult.ppoAMPSDBEngineTable[unRowCount] = (t_AMPSDBEngineTable*)AMPS_InternalMalloc(sizeof(t_AMPSDBEngineTable) * oAMPSDBEngineResult.ulNumberOfColumns);
			if(NULL == oAMPSDBEngineResult.ppoAMPSDBEngineTable[unRowCount])
			{
				//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "AMPS_InternalMalloc failed for r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter].\n");
				return AMPS_ERROR_FAILURE;
			}
			//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "Pointer = %p.\n",  r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter]);

			for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
			{
				//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Column %u is %lu bytes in length and value %s.\n", (ulColumnCounter + 1), pulLengthOfField[ulColumnCounter], oMYSQLRow[ulColumnCounter]);

				oAMPSDBEngineResult.ppoAMPSDBEngineTable[unRowCount][unColumnCount].pchField = AMPS_InternalMalloc(poOracleContext->poOracleColumnData[unColumnCount].nValueLen);
				oAMPSDBEngineResult.ppoAMPSDBEngineTable[unRowCount][unColumnCount].nLengthOfField = poOracleContext->poOracleColumnData[unColumnCount].nValueLen;
				//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Field Length = %d.\n", r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][ulColumnCounter].nLengthOfField);

				memcpy(oAMPSDBEngineResult.ppoAMPSDBEngineTable[unRowCount][unColumnCount].pchField, poOracleContext->poOracleColumnData[unColumnCount].puchValue, poOracleContext->poOracleColumnData[unColumnCount].nValueLen);
				//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Filed Value = %s.\n", r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][ulColumnCounter].pchField);
			}
		}

		oAMPSDBEngineResult.ulNumberOfRows = atoi(oAMPSDBEngineResult.ppoAMPSDBEngineTable[0][0].pchField);
	}
	if(hOCIParam)
	{
		//ignore result code
		OCIDescriptorFree(hOCIParam, OCI_DTYPE_PARAM);
	}
	for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
	{
		if(NULL != poOracleContext->poOracleColumnData[unColumnCount].puchValue)
		{
			AMPS_InternalFree(poOracleContext->poOracleColumnData[unColumnCount].puchValue);
			poOracleContext->poOracleColumnData[unColumnCount].nValueLen = 0;
		}
	}
	return(oAMPSDBEngineResult.ulNumberOfRows);
#endif
	return 0;
}

/*****************************************************************
函数名称: Oracle_Query
功能描述: 执行SQL查询语句
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文
      const char* r_pcchQueryStatement SQL查询语句
      unsigned long r_ulLengthOfQuery SQL查询语句长度
      t_AMPSDBEngineResult* r_poAMPSDBEngineResult 结果集

出参:
      
返回值:
    int

*****************************************************************/
int Oracle_Query(void* r_pvAMPSContext, void* r_pvBDEngineContext, const char* r_pcchQueryStatement, unsigned long r_ulLengthOfQuery, t_AMPSDBEngineResult* r_poAMPSDBEngineResult)
{
#ifdef WIN32
	t_BDEngineContext* poBDEngineContext = r_pvBDEngineContext;
	t_OracleContext* poOracleContext = poBDEngineContext->poDBHandle;
	OCIStmt* hOCIStmt = NULL;
	signed int nReturnCode = OCI_ERROR;

	//allocate statement handle
	nReturnCode = OCIHandleAlloc(poOracleContext->hOCIEnv, (void**)&hOCIStmt, OCI_HTYPE_STMT, 0, NULL);
	if(nReturnCode == OCI_SUCCESS)
	{
		if(r_ulLengthOfQuery == -1)
		{
			r_ulLengthOfQuery = strlen(r_pcchQueryStatement);
		}
		nReturnCode = OCIStmtPrepare(hOCIStmt, poOracleContext->hOCIError, (unsigned char*)r_pcchQueryStatement, r_ulLengthOfQuery, OCI_NTV_SYNTAX, OCI_DEFAULT);
		if(nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}
	}
	if(nReturnCode == OCI_SUCCESS)
	{
		unsigned short ushStmtType = 0;
		nReturnCode = OCIAttrGet(hOCIStmt, OCI_HTYPE_STMT, &ushStmtType, NULL, OCI_ATTR_STMT_TYPE, poOracleContext->hOCIError);
		if (nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}
		// returns 0 (ST_UNKNOWN) if sql statement is wrong
		//TODO
		if(OCI_STMT_SELECT == ushStmtType)
		{
			//Define array of define structure
			//t_ColumnData poColumnDataDef[MAX_SELECT_LIST_SIZE];
			OCIDefine* hOCIDefine = NULL;
			OCIParam* hOCIParam = NULL;
			unsigned int unSize = 0;
			unsigned int unNoOfColumns = 0;
			unsigned int unColumnCount = 0;
			unsigned int unRowCount = 0;

			memset(poOracleContext->poOracleColumnData, 0, (sizeof(t_OracleColumnData) * ORACLE_MAX_SELECT_COLUMN_LIST_SIZE));

			unRowCount = (unsigned int)Oracle_GetNumberOfRecords(r_pvAMPSContext, r_pvBDEngineContext, r_pcchQueryStatement, r_ulLengthOfQuery);
			if(0 == unRowCount)
			{
				return AMPS_ERROR_FAILURE;
			}

			nReturnCode = OCIStmtExecute(poOracleContext->hOCISvcCtx, hOCIStmt, poOracleContext->hOCIError, 0, 0, NULL, NULL, OCI_DEFAULT);
			if(nReturnCode != OCI_SUCCESS)
			{
				Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
				return AMPS_ERROR_FAILURE;
			}

			nReturnCode = OCIAttrGet(hOCIStmt, OCI_HTYPE_STMT, &unNoOfColumns, NULL, OCI_ATTR_PARAM_COUNT, poOracleContext->hOCIError);
			if(nReturnCode != OCI_SUCCESS)
			{
				Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
				return AMPS_ERROR_FAILURE;
			}

			//get next column info
			for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
			{
				nReturnCode = OCIParamGet(hOCIStmt, OCI_HTYPE_STMT, poOracleContext->hOCIError, (void**)&hOCIParam, unColumnCount + 1);
				if(nReturnCode != OCI_SUCCESS)
				{
					Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
					return AMPS_ERROR_FAILURE;
				}

				// maximum data size in bytes
				unSize = 0;
				nReturnCode = OCIAttrGet(hOCIParam, OCI_DTYPE_PARAM, &unSize, NULL, OCI_ATTR_DATA_SIZE, poOracleContext->hOCIError);
				if(nReturnCode != OCI_SUCCESS)
				{
					Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
					return AMPS_ERROR_FAILURE;
				}

				poOracleContext->poOracleColumnData[unColumnCount].puchValue = AMPS_InternalMalloc(unSize + 1);
				poOracleContext->poOracleColumnData[unColumnCount].nValueLen = unSize;
				memset(poOracleContext->poOracleColumnData[unColumnCount].puchValue, 0, poOracleContext->poOracleColumnData[unColumnCount].nValueLen);

				nReturnCode = OCIDefineByPos(hOCIStmt, &hOCIDefine, poOracleContext->hOCIError, unColumnCount + 1, poOracleContext->poOracleColumnData[unColumnCount].puchValue, unSize, STRING_TYPE, NULL, NULL, NULL, OCI_DEFAULT);
				if(nReturnCode != OCI_SUCCESS)
				{
					Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
					return AMPS_ERROR_FAILURE;
				}
			}

			r_poAMPSDBEngineResult->ulNumberOfColumns = unNoOfColumns;
			r_poAMPSDBEngineResult->ulNumberOfRows = unRowCount;
			r_poAMPSDBEngineResult->ulNumberOfResults = r_poAMPSDBEngineResult->ulNumberOfRows;

			if (0 < r_poAMPSDBEngineResult->ulNumberOfRows) 
			{
				r_poAMPSDBEngineResult->ppoAMPSDBEngineTable = (t_AMPSDBEngineTable**)AMPS_InternalMalloc(sizeof(t_AMPSDBEngineTable*) * r_poAMPSDBEngineResult->ulNumberOfRows);
				if(NULL == r_poAMPSDBEngineResult->ppoAMPSDBEngineTable)
				{
					//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "AMPS_InternalMalloc failed for r_poBDEngineResult->ppoAMPSDBEngineTable.\n");
					return AMPS_ERROR_FAILURE;
				}

				//printf("\n\n r_poBDEngineResult->ulNumberOfRows is %ld  r_poBDEngineResult->ulNumberOfColumns %ld and r_poBDEngineResult->ppoAMPSDBEngineTable %p\n\n",r_poBDEngineResult->ulNumberOfRows, r_poBDEngineResult->ulNumberOfColumns, r_poBDEngineResult->ppoAMPSDBEngineTable);

				for(unRowCount = 0; unRowCount < r_poAMPSDBEngineResult->ulNumberOfRows; unRowCount++)
				{
					nReturnCode = OCIStmtFetch(hOCIStmt, poOracleContext->hOCIError, 1, OCI_FETCH_NEXT, OCI_DEFAULT);
					if(nReturnCode != OCI_SUCCESS)
					{
						Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
						break;
					}

					r_poAMPSDBEngineResult->ppoAMPSDBEngineTable[unRowCount] = (t_AMPSDBEngineTable*)AMPS_InternalMalloc(sizeof(t_AMPSDBEngineTable) * r_poAMPSDBEngineResult->ulNumberOfColumns);
					if(NULL == r_poAMPSDBEngineResult->ppoAMPSDBEngineTable[unRowCount])
					{
						//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "AMPS_InternalMalloc failed for r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter].\n");
						return AMPS_ERROR_FAILURE;
					}
					//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "Pointer = %p.\n",  r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter]);

					for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
					{
						//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Column %u is %lu bytes in length and value %s.\n", (ulColumnCounter + 1), pulLengthOfField[ulColumnCounter], oMYSQLRow[ulColumnCounter]);

						r_poAMPSDBEngineResult->ppoAMPSDBEngineTable[unRowCount][unColumnCount].pchField = AMPS_InternalMalloc(poOracleContext->poOracleColumnData[unColumnCount].nValueLen);
						r_poAMPSDBEngineResult->ppoAMPSDBEngineTable[unRowCount][unColumnCount].nLengthOfField = poOracleContext->poOracleColumnData[unColumnCount].nValueLen;
						//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Field Length = %d.\n", r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][ulColumnCounter].nLengthOfField);

						memcpy(r_poAMPSDBEngineResult->ppoAMPSDBEngineTable[unRowCount][unColumnCount].pchField, poOracleContext->poOracleColumnData[unColumnCount].puchValue, poOracleContext->poOracleColumnData[unColumnCount].nValueLen);
						//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Filed Value = %s.\n", r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][ulColumnCounter].pchField);
					}
				}

				r_poAMPSDBEngineResult->ulNumberOfRows = unRowCount;
			}
			if(hOCIParam)
			{
				//ignore result code
				OCIDescriptorFree(hOCIParam, OCI_DTYPE_PARAM);
			}
			for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
			{
				if(NULL != poOracleContext->poOracleColumnData[unColumnCount].puchValue)
				{
					AMPS_InternalFree(poOracleContext->poOracleColumnData[unColumnCount].puchValue);
					poOracleContext->poOracleColumnData[unColumnCount].nValueLen = 0;
				}
			}
		}
		else
		{
			nReturnCode = OCIStmtExecute(poOracleContext->hOCISvcCtx, hOCIStmt, poOracleContext->hOCIError, 1, 0, NULL, NULL, OCI_COMMIT_ON_SUCCESS);
			if (nReturnCode != OCI_SUCCESS)
			{
				Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			}
		}
	}

#endif
	return AMPS_SUCCESS;
}

/*****************************************************************
函数名称: Oracle_FreeResults
功能描述: 释放查询结果集
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文
      const char* r_pcchQueryStatement SQL查询语句
      unsigned long r_ulLengthOfQuery SQL查询语句长度

出参:
      
返回值:
    int

*****************************************************************/
void Oracle_FreeResults(void* r_pvAMPSContext, void* r_pvBDEngineContext, t_AMPSDBEngineResult* r_poBDEngineResult)
{
#ifdef WIN32
	unsigned long ulRowCounter = 0;
	unsigned long unColumnCounter = 0;

	//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_INFO, "Entering.\n");

	//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "No of Rows %lu.\n", r_poBDEngineResult->ulNumberOfRows);

	if (0 < r_poBDEngineResult->ulNumberOfRows) 
	{
		for(ulRowCounter = 0; ulRowCounter < r_poBDEngineResult->ulNumberOfRows; ulRowCounter++)
		{
			for(unColumnCounter = 0; unColumnCounter < r_poBDEngineResult->ulNumberOfColumns; unColumnCounter++)
			{
				AMPS_InternalFree(r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][unColumnCounter].pchField);
				r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][unColumnCounter].nLengthOfField = 0;
			}
			//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Free Counter %lu.\n", ulRowCounter);
			//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "Pointer = %p.\n",  r_poBDEngineResult)->ppoAMPSDBEngineTable[ulRowCounter]);
			AMPS_InternalFree(r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter]);
		}

		r_poBDEngineResult->ulNumberOfColumns = 0;
		r_poBDEngineResult->ulNumberOfRows = 0;
		r_poBDEngineResult->ulNumberOfResults = 0;

		AMPS_InternalFree(r_poBDEngineResult->ppoAMPSDBEngineTable);
	}
	//mysql_free_result(r_poBDEngineResult->pvResultObj);
#endif
}

/*****************************************************************
函数名称: Oracle_CheckError
功能描述: 错误处理函数
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文
      signed int r_nStatus 错误码


出参:
      
返回值:
    int

*****************************************************************/
void Oracle_CheckError(void* r_pvAMPSContext, void* r_pvBDEngineContext, signed int r_nStatus)
{
#ifdef WIN32
	t_BDEngineContext* poBDEngineContext = r_pvBDEngineContext;
	t_OracleContext* poOracleContext = poBDEngineContext->poDBHandle;
	unsigned char puchErrorBufer[512];
	signed int nErrorCode = 0;

	switch (r_nStatus)
	{
		case OCI_SUCCESS:
			break;
		case OCI_SUCCESS_WITH_INFO:
			printf("Error - OCI_SUCCESS_WITH_INFO\n");
			break;
		case OCI_NEED_DATA:
			printf("Error - OCI_NEED_DATA\n");
			break;
		case OCI_NO_DATA:
			printf("Error - OCI_NODATA\n");
			break;
		case OCI_ERROR:
			OCIErrorGet((void*)poOracleContext->hOCIError, 1, (unsigned char*) NULL, &nErrorCode, puchErrorBufer, sizeof(puchErrorBufer), OCI_HTYPE_ERROR);
			printf("Error - %.*s\n", 512, puchErrorBufer);
			break;
		case OCI_INVALID_HANDLE:
			printf("Error - OCI_INVALID_HANDLE\n");
			break;
		case OCI_STILL_EXECUTING:
			printf("Error - OCI_STILL_EXECUTE\n");
			break;
		case OCI_CONTINUE:
			printf("Error - OCI_CONTINUE\n");
			break;
		default:
			break;
	}
#endif
}


socrates
关注
专栏目录
OCIEnvCreate 失败,返回代码为 -1,但错误消息文本不可用 问题处理
weixin_30949361的博客
12-17 1795
OCIEnvCreate 失败,返回代码为 -1,但错误消息文本不可用 问题处理如下： 解决方法一：更换连接方式 config 文件配置： <add name="MASTER_DB" connectionString="Provider=MSDAORA;Data Source=jhemr;Password=jhemr;User ID=jhemr;" providerName="Sys...
java jdbc 连接oracle数据库连接报错ORA-12505,Listener refused the connection with the following error:
weixin_39172079的博客
06-14 1766
java.sql.SQLException:Listener refused the connection with the following error:ORA-12505错误日志问题分析最后强调：SID != SERVICE_NAME 错误日志 java.sql.SQLException:Listener refused the connection with the following...
C#中连接Oracle数据库时提示OCIEnvCreate 失败，返回代码为 -1，但错误消息文本不可用。
greatfeather的专栏
03-10 3939
本文讲述了在C#中当使用OracleClient连接数据库时提示“OCIEnvCreate 失败，返回代码为 -1，但错误消息文本不可用。”时的另类解决方案。
oracle ocienvcreate,OCIEnvCreate 失败，返回代码为 -1的解决方法
weixin_30466329的博客
04-13 3259
错误描述连接Oracle始终报这个错误:{System.Exception: OCIEnvCreate 失败，返回代码为 -1，但错误消息文本不可用本机环境是oracle10g客户端，以前也连过，但现在出了问题，同样的程序在其他电脑上没问题，所以排除代码、连接字符串等问题，本机上的数据库管理工具也能正常执行相关SQL语句。网上一般说有如下几种情况会导致此报错：(1)客户机上未安装oracle客户端...
ocienvcreate php 失败_OCI 学习笔记(转)
weixin_39880895的博客
01-28 317
这段自学 OCI 编程，感觉网上这方面的资料其实也不少，只是不是很容易找到。其实 OCI没有想象的那么复杂，如果你想深究，那应该就只是时间问题。我在网上看到有人这么写到，对于 C 高手来说 OCI编程只是简单的调用接口函数而已。我个人认为，学习 OCI 编程真的没那么难的，如果你想简单的会使用。那么接下来我就这段时间对 OCI 函数的学习及所收集的资料进行整合，用于帮助那些刚刚接触 OCI 编程的...
OCIEnvCreate 失败，返回代码为 -1，但错误消息文本不可用
清风专栏
08-19 2602
网上的提供的方法也是试了一遍，包括卸载重装Oracle客户端的，程序生成目标也改成 any cpu, 依然不行。 解决方法： 发现自己程序，前台部分用的是64位的，而后台是32位的，之前电脑上只有32位的Oracle客户端，把64位的客户端也装上，问题解决。 ...
AMPS:MySQL数据库操作模块源码解读
Socrates的专栏
01-25 3340
本节看看在AMPS中对MySQL数据库的访问操作，它使用MySQL提供的C API接口进行访问，具体各API的使用可参考http://dev.mysql.com/doc/refman/5.6/en/c-api-function-overview.html。  下面看看AMPS中的实现：   AMPS_MySQL.h #ifndef __HEADER_AMPS_MYSQL_ENGINE_H #
AMPS:数据库访问模块源码解读
Socrates的专栏
01-25 3108
AMPS做为一个中间件，也提供了访问数据库的接口，目前支持MySQL和Oracle（对我所喜爱PostgreSQL却默认不支持，看来我的爱好属于非主流哈~），下面要看的是DBEngine库，它只做一件事情，就是封装了不同数据库操作的差异，提供一个数据库统一访问接口。下节再看针对不同数据库的具体操作。 AMPS_DBEngine.h #ifndef __HEADER_AMPS_DB_ENGI
C:\Users\Administrator\Desktop\诺蒂菲尔设备资料AMPS-24.PDF
09-10
诺蒂菲尔设备资料AMPS-24、诺蒂菲尔设备资料AMPS-24、
oracledb_exporter.linux-amd64
04-13
oracledb_exporter.linux-amd64 监控oracle 以防以后忘记
【推荐】ON SEMI 运算放大器(Op Amps) 技术资料合集.zip
09-17
推荐，ON SEMI 运算放大器(Op Amps) 技术资料合集，共107份。 FAN3852-D 麦克风预放大器，带数字输出 FAN4174 运算放大器，轨对轨 IO，3.7Mhz，CMOS 运算放大器 FAN4274-D Single and Dual, Rail-to-Rail IO, CMOS ...
GMapsNearbyPlacesAPI：Google amps附近的地方搜索-> * lat * lon * rad
02-18
GMapsNearbyPlacesAPI 一个g.maps项​​目，根据输入的输入内容搜索附近的地点* lat * lon * rad 这是您可以使用Google Maps制作restApi的项目 用户应该输入输入值lat，long，rad，这是地球上的一个点 ...
AMPS-1D太阳电池模拟软件
02-29
### AMPS-1D太阳电池模拟软件知识点解析 #### 一、AMPS-1D概述 **AMPS-1D**（Analytical Modeling Program with Simulations - 1 Dimensional）是一款由美国宾夕法尼亚州立大学电子材料工艺研究实验室提供的专业一...
OCI释放句柄时应注意的问题
evilstar2015的专栏
03-16 1073
在项目开发过程中，遇到过这样的问题： 代码中，需要访问两个数据库（定为数据库A,和数据库B）。在从数据库A切换到数据库B的时候，要释放A所有申请的资源。 由于模型设计原因，在申请句柄时，在不同的地方申请了2个 错误 句柄。 在释放时，执行了如下语句：         if (srvhpt!=NULL)                 (void) OCIHandleFree((dvoid
AMPS:AES模块源码解读
Socrates的专栏
01-23 5693
AES(Advanced Encryption Standard，高级加密标准)是一个对称密钥加密算法，密钥长度则可以是128，192或256比特。  算法思路(详细信息请见维基百科)：   AES加密过程是在一个4×4的字节矩阵上运作，这个矩阵又称为“体（state）”，其初值就是一个明文区块（矩阵中一个元素大小就是明文区块中的一个Byte）。（Rijndael加密法因支持更大的区块
AMPS:哈希表源码解读
Socrates的专栏
01-21 3486
Hash表也是一种常用的数据结构，AMPS中的Hash表并不是给使用者提供一个散列函数，而是仅提供一个创建和维护Hash表这样一个结构的一组函数，针对不同的应用或者数据，由用户自己定义其要使用的散列函数，AMPS中，Hash表组成结构是如下的拉链式结构。 下面看看AMPS中对Hash操作的代码： AMPS_Hash.h #ifndef __HEADER_AMPS_HASH_H #
AMPS:内存管理模块源码解读（一）
Socrates的专栏
01-27 3241
在AMPS中，使用内存池来管理内存，具体机制见之前的文章《AMPS:内存管理（二）》，在代码中，使用了两种实现方式，第一种是数组+单链表。今天先看看这个方式下的内存池实现。 AMPS_MemoryMgt.h #ifndef __HEADER_AMPS_MEMORY_MGMT_H__ #define __HEADER_AMPS_MEMORY_MGMT_H__ #include "AMPS_
第三版Op Amps设计指南：实用设计工具和解决方案
Op Amps for Everyone (第三版) - Operational Amplifier 设计指南 Op Amps for Everyone (第三版) 是一本关于运算放大器（Operational Amplifier，简称 Op Amp）设计的指南，由 Ron Mancini 和 Bruce Carter 编辑...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值