Oracle 中oci 关于null 的处理方法(二)

2014-11-24 17:59:52 · 作者: · 浏览: 2
ct(defhp1,errhp,sizeof(int),0,4,0));
//!绑定以二个列


indicator = -2;
ERRGOTO(OCIDefineByPos(stmthp,&defhp2,errhp,2,&b, 20, SQLT_CHR, (void*)&indicator, 0, 0, OCI_DEFAULT));
//ERRGOTO(OCIDefineArrayOfStruct(defhp2,errhp,2,0,2,0));
//!执行语句
ERRGOTO(OCIStmtExecute(svchp,stmthp,errhp,1,0,0,0,OCI_DEFAULT));
//ERRGOTO(OCIStmtFetch(stmthp,errhp,1,OCI_FETCH_NEXT,0));


printf("%d, %s, %d", a, b, indicator);


ERRGOTO(OCITransCommit(svchp,errhp,0));



//!释放各个资源

//ERRGOTO(OCIHandleFree(srvhp,OCI_HTYPE_SERVER));
//ERRGOTO(OCIHandleFree(errhp,OCI_HTYPE_ERROR));
//ERRGOTO(OCIHandleFree(envhp,OCI_HTYPE_ENV));



return ;
ERR:
sb4 errcod=0;
OraText msgerr[200]="";
OraText msgstat[200]="";
OCIErrorGet(errhp,1,msgstat,&errcod,msgerr,200,OCI_HTYPE_ERROR);
printf((char *)msgerr);
return;



}