oci8.c

适合于Unix/Linux下的一个持久数据库连接池

// Connect, Authorize, and Initialize Functions
	//OCIConnectionPoolCreate()
	//OCIConnectionPoolDestroy()
	OCIEnvCreate()
	OCIEnvInit()
	OCIEnvNlsCreate() - call OCIEnvCreate()
	OCIInitialize()
	OCILogoff()
	OCILogon()
	OCILogon2() - call OCILogon()
	OCIServerAttach()
	OCIServerDetach()
	OCISessionBegin()
	OCISessionEnd()
	OCISessionGet()
	//OCISessionPoolCreate()
	//OCISessionPoolDestroy()
	OCISessionRelease()
	OCITerminate()

// Handle and Descriptor Functions
	OCIAttrGet()
	OCIAttrSet()
	OCIDescriptorAlloc()
	OCIDescriptorFree()
	OCIHandleAlloc()
	OCIHandleFree()
	OCIParamGet()
	OCIParamSet()

// Bind, Define, and Describe Functions
	//OCIBindArrayOfStruct()
	OCIBindByName()
	OCIBindByPos()
	//OCIBindDynamic()
	//OCIBindObject()
	//OCIDefineArrayOfStruct()
	OCIDefineByPos()
	//OCIDefineDynamic()
	//OCIDefineObject
	//OCIDescribeAny()
	//OCIStmtGetBindInfo()

// Statement Functions
	OCIStmtExecute()
	OCIStmtFetch()
	OCIStmtFetch2() - call OCIStmtFetch()
	OCIStmtGetPieceInfo()
	OCIStmtPrepare()
	OCIStmtPrepare2() - call OCIStmtPrepare()
	OCIStmtRelease()
	//OCIStmtSetPieceInfo()

// LOB Functions
	//OCIDurationBegin()
	//OCIDurationEnd()
	//OCILobAppend()
	//OCILobAssign()
	//OCILobCharSetForm()
	//OCILobCharSetId()
	OCILobClose()
	//OCILobCopy()
	OCILobCreateTemporary()
	//OCILobDisableBuffering()
	//OCILobEnableBuffering()
	//OCILobErase()
	//OCILobFileClose()
	//OCILobFileCloseAll()
	//OCILobFileExists()
	//OCILobFileGetName()
	//OCILobFileIsOpen()
	//OCILobFileOpen()
	//OCILobFileSetName()
	//OCILobFlushBuffer()
	OCILobFreeTemporary()
	//OCILobGetChunkSize()
	OCILobGetLength()
	//OCILobIsEqual()
	//OCILobIsOpen()
	OCILobIsTemporary()
	//OCILobLoadFromFile()
	//OCILobLocatorAssign()
	//OCILobLocatorIsInit()
	OCILobOpen()
	OCILobRead()
	//OCILobTrim()
	OCILobWrite()
	//OCILobWriteAppend()

// Advanced Queuing and Publish-Subscribe Functions
// Direct Path Loading Functions
// Thread Management Functions

// Transaction Functions
	OCITransCommit()
	//OCITransDetach()
	//OCITransForget()
	//OCITransMultiPrepare()
	//OCITransPrepare()
	OCITransRollback()
	//OCITransStart()

// Miscellaneous Functions
	//OCIBreak()
	OCIErrorGet()
	//OCILdaToSvcCtx()
	//OCINlsEnvironmentVariableGet()
	//OCIPasswordChange()
	//OCIReset()
	//OCIRowidToChar()
	OCIServerVersion()
	//OCISvcCtxToLda()
	//OCIUserCallbackGet()
	//OCIUserCallbackRegister()


// OCI Flush or Refresh Functions
// OCI Mark or Unmark Object and Cache Functions
// OCI Get Object Status Functions
// OCI Miscellaneous Object Functions
// OCI Pin, Unpin, and Free Functions
// OCI Type Information Accessor Functions
// OCI Collection and Iterator Functions
// OCI Date, Datetime, and Interval Functions
// OCI Number Functions
// OCI Raw Functions
// OCI Ref Functions
// OCI String Functions
// OCI Table Functions
// Cartridge Services -- OCI External Procedures
// Cartridge Services -- Memory Services
// Cartridge Services -- Maintaining Context
// Cartridge Services -- Parameter Manager Interface
// Cartridge Services -- File I/O Interface
// Cartridge Services -- String Formatting Interface
// OCI Type Interface Functions
// OCI Any Data Interface Functions
// OCI Any Data Set Interface Functions


#ifdef HAVE_ORACLE_8i
OCIEnvCreate((OCIEnv **)&env,OCI_DEFAULT,(dvoid *)0,
				(dvoid *(*)(dvoid *, size_t))0,
				(dvoid *(*)(dvoid *, dvoid *, size_t))0,
				(void (*)(dvoid *, dvoid *))0,
				(size_t)0,(dvoid **)0) {
}

#else
OCIInitialize(OCI_DEFAULT,NULL,NULL,NULL,NULL) {
}

OCIEnvInit((OCIEnv **)&env,OCI_DEFAULT,0,(dvoid **)0) {
}

#endif

OCIHandleAlloc((dvoid *)env,(dvoid **)&err,OCI_HTYPE_ERROR,0,NULL) {
	OCI_HTYPE_ERROR
	OCI_HTYPE_SERVER
	OCI_HTYPE_SVCCTX
	OCI_HTYPE_SERVER
	OCI_HTYPE_TRANS
	OCI_HTYPE_SESSION
	OCI_HTYPE_STMT
}

OCIHandleFree(svc,OCI_HTYPE_SVCCTX) {
	OCI_HTYPE_ERROR
	OCI_HTYPE_SERVER
	OCI_HTYPE_SVCCTX
	OCI_HTYPE_SERVER
	OCI_HTYPE_TRANS
	OCI_HTYPE_SESSION
	OCI_HTYPE_STMT
}

OCIServerAttach(srv,err,(text *)sid,charstring::length(sid),0) {
}

OCIServerDetach(srv,err,OCI_DEFAULT) {
}

OCIAttrSet((dvoid *)svc,OCI_HTYPE_SVCCTX,
				(dvoid *)srv,(ub4)0,
				OCI_ATTR_SERVER,(OCIError *)err) {
	OCI_HTYPE_SVCCTX
		OCI_ATTR_SERVER
		OCI_ATTR_SESSION
		OCI_ATTR_TRANS
	OCI_HTYPE_SESSION
		OCI_ATTR_USERNAME
		OCI_ATTR_PSSSWORD
}

OCIAttrGet((dvoid *)stmt,OCI_HTYPE_STMT,
				(dvoid *)&ncols,(ub4 *)NULL,
				OCI_ATTR_PARAM_COUNT,
				oracle8conn->err) {
	OCI_HTYPE_STMT
		OCI_ATTR_STMT_TYPE
		OCI_ATTR_PARAM_COUNT
		OCI_ATTR_ROW_COUNT
	OCI_DTYPE_PARAM
		OCI_ATTR_NAME
		OCI_ATTR_DATA_TYPE
		OCI_ATTR_PRECISION
		OCI_ATTR_SCALE
		OCI_ATTR_IS_NULL
		OCI_ATTR_DATA_SIZE
}


OCISessionBegin(svc,err,session,OCI_CRED_RDBMS,(ub4)OCI_DEFAULT) {
}


OCISessionEnd(svc,err,session,OCI_DEFAULT) {
}

OCIServerVersion((dvoid *)svc,err,(text *)versionbuf,
				sizeof(versionbuf),OCI_HTYPE_SVCCTX) {
}


OCIErrorGet((dvoid *)err,1,(text *)0,&errcode,
				message,sizeof(message),OCI_HTYPE_ERROR) {
}

OCITransCommit(svc,err,OCI_DEFAULT) {
}


OCITransRollback(svc,err,OCI_DEFAULT) {
}



OCIStmtPrepare(stmt,oracle8conn->err,
				(text *)query,(ub4)length,
				(ub4)OCI_NTV_SYNTAX,
				(ub4)OCI_DEFAULT) {
}


OCIBindByPos(stmt,&inbindpp[inbindcount],
				oracle8conn->err,
				(ub4)charstring::toInteger(variable+1),
				(dvoid *)value,(sb4)valuesize+1,
				SQLT_STR,
				(dvoid *)isnull,(ub2 *)0,
				(ub2 *)0,0,(ub4 *)0,
				OCI_DEFAULT) {
	SQLT_STR
	SQLT_FLT
	SQLT_BLOB
	SQLT_CLOB
}


OCIBindByName(stmt,&inbindpp[inbindcount],
				oracle8conn->err,
				(text *)variable,(sb4)variablesize,
				(dvoid *)value,(sb4)valuesize+1,
				SQLT_STR,
				(dvoid *)isnull,(ub2 *)0,
				(ub2 *)0,0,(ub4 *)0,
				OCI_DEFAULT) {
	SQLT_STR
	SQLT_FLT
	SQLT_BLOB
	SQLT_CLOB
}



OCIDescriptorAlloc((dvoid *)oracle8conn->env,
			(dvoid **)&inbind_lob[inbindlobcount],
			(ub4)OCI_DTYPE_LOB,
			(size_t)0,(dvoid **)0) {
	OCI_DTYPE_LOB
}

OCIDescriptorFree(inbind_lob[inbindlobcount],OCI_DTYPE_LOB) {
	OCI_DTYPE_LOB
}

OCILobCreateTemporary(oracle8conn->svc,oracle8conn->err,
			inbind_lob[inbindlobcount],
			//(ub2)0,SQLCS_IMPLICIT,
			(ub2)OCI_DEFAULT,OCI_DEFAULT,
			temptype,OCI_ATTR_NOCACHE,
			OCI_DURATION_SESSION) {
}

OCILobIsTemporary(oracle8conn->env,oracle8conn->err,
					def_lob[col][row],
					&templob) {
}

OCILobFreeTemporary(oracle8conn->svc,oracle8conn->err,
					inbind_lob[inbindlobcount]) {
}

OCILobOpen(oracle8conn->svc,oracle8conn->err,
			inbind_lob[inbindlobcount],
			OCI_LOB_READWRITE) {
}


OCILobWrite(oracle8conn->svc,oracle8conn->err,
			inbind_lob[inbindlobcount],&size,1,
			(void *)value,valuesize,
			OCI_ONE_PIECE,(dvoid *)0,
			(sb4 (*)(dvoid*,dvoid*,ub4*,ub1 *))0,
			0,SQLCS_IMPLICIT) {
}


OCILobRead(oracle8conn->svc,oracle8conn->err,
				outbind_lob[index],
				&retlen,
				offset,
				(dvoid *)buf,
				oracle8conn->maxitembuffersize,
				(dvoid *)NULL,
				(sb4(*)(dvoid *,CONST dvoid *,ub4,ub1))NULL,
				(ub2)0,
				(ub1)SQLCS_IMPLICIT) {
}

OCILobClose(oracle8conn->svc,oracle8conn->err,inbind_lob[inbindlobcount]) {
}

OCILobGetLength(oracle8conn->svc,
			oracle8conn->err,
			outbind_lob[index],
			&loblength) {
}


OCIStmtExecute(oracle8conn->svc,stmt,
				oracle8conn->err,iters,
				(ub4)0,NULL,NULL,
				oracle8conn->statementmode) {
}


OCIParamGet(stmt,OCI_HTYPE_STMT,oracle8conn->err,
				(dvoid **)&desc[i].paramd,
				i+1) {
}


OCIDefineByPos(stmt,&def[i],oracle8conn->err,
					i+1,
					(dvoid *)def_buf[i],
					(sb4)oracle8conn->maxitembuffersize,
					SQLT_STR,
					(dvoid *)def_indp[i],
					(ub2 *)def_col_retlen[i],
					def_col_retcode[i],
					OCI_DEFAULT) {
}


OCIStmtFetch(stmt,oracle8conn->err,oracle8conn->fetchatonce,
						OCI_FETCH_NEXT,OCI_DEFAULT) {
	OCI_FETCH_NEXT
}