OCI批量新增数据时数据长度的问题

2010-12-14 03:24:42 149 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Calibre license失效的解决方法 Calibre license失效的解决方法阅读详情

字段q_id的类型为varchar(45)，更新数据时，如果q_id字符串的长度刚好为45时，没有问题，可实际上q_id字符串的长度可能小于45，例如当q_id="ID1000"时，实际存入数据库中的值为"ID1000"+乱码，怎么解决？
表结构：
create table testtable
(
q_id varchar(45),
qq_flag varchar(2),
qvalue decimal(20,2)
)
批量新增数据的函数：



int OCI_TOOLS::ORA_BindArrayWithupdatead(char *buff, float qvalue[], char q_id[][45],char qq_flag[][2],int maxiter)

{

  text *sqltext;

  int i;

  sword ret1,ret2,ret3,ret4;

  text msgbuf[512];



  /* bind handles will be implicitly allocated in the bind calls */

  /* need to initialize them to null prior to first usage in bind calls */



  OCIBind *bnd1p = (OCIBind *) 0; /* the first bind handle */

  OCIBind *bnd2p = (OCIBind *) 0; /* the second bind handle */

  OCIBind *bnd3p = (OCIBind *) 0; /* the third bind handle */



  text *sqlstmt = (text *)buff;



  if (OCIStmtPrepare(stmthp, errhp, sqlstmt, (ub4)strlen((char *)sqlstmt),

  (ub4) OCI_NTV_SYNTAX, (ub4) OCI_DEFAULT))

  {

  (void) printf("FAILED: OCIStmtPrepare() update\n");

  //report_error(errhp);

  return OCI_ERROR;

  }

  ret1=OCIBindByPos(stmthp, &bnd1p,errhp, (ub4) 1,

  (dvoid *) qvalue, (sb4) 4, SQLT_FLT,

  (dvoid *) 0, (ub2 *)0, (ub2 *)0,

  (ub4) 0, (ub4 *) 0, (ub4) OCI_DEFAULT);



  ret3=OCIBindByPos(stmthp, &bnd3p,errhp, (ub4) 3,

  (dvoid *) q_id, (sb4) 45, SQLT_CHR,

  (dvoid *) 0, (ub2 *)0, (ub2 *)0,

  (ub4) 0, (ub4 *) 0, (ub4) OCI_DEFAULT);



  ret2=OCIBindByPos(stmthp, &bnd2p,errhp, (ub4) 2,

  (dvoid *) qq_flag, (sb4) 2, SQLT_CHR,

  (dvoid *) 0, (ub2 *)0, (ub2 *)0,

  (ub4) 0, (ub4 *) 0, (ub4) OCI_DEFAULT);





  if (ret1||ret2||ret3)

  {

  (void) printf("FAILED: OCIBindArrayOfStruct()\n");

  //report_error(errhp);

  return OCI_ERROR;

  }



  ret1=OCIBindArrayOfStruct(bnd1p,errhp, 4, 0, 0, 0);

  ret3=OCIBindArrayOfStruct(bnd3p,errhp, 45, 0, 0, 0);

  ret2=OCIBindArrayOfStruct(bnd2p,errhp, 2, 0, 0, 0);



  if (ret1||ret2||ret3)

  {

  (void) printf("FAILED: OCIBindArrayOfStruct()\n");

  //report_error(errhp);

  return OCI_ERROR;

  }







  if (OCIStmtExecute(svchp, stmthp,errhp, (ub4) maxiter, (ub4) 0,

  (CONST OCISnapshot*) 0, (OCISnapshot*) 0,

  (ub4) OCI_COMMIT_ON_SUCCESS))

  {

  (void) printf("FAILED: OCIStmtExecute() update ccbase\n");

  //report_error(errhp);

  sb4 errcode = 0;

  (void) OCIErrorGet((dvoid *) errhp, (ub4) 1, (text *) NULL, &errcode,

  msgbuf, (ub4) sizeof(msgbuf), (ub4) OCI_HTYPE_ERROR);

  (void) printf("ERROR CODE = %d\n", errcode);

  (void) printf("%.*s\n", 512, msgbuf);

  return OCI_ERROR;

  }

  status=OCITransCommit(svchp,errhp,0);

  if(status!=OCI_SUCCESS)

  {

  error_proc(errhp,status);

  return OCI_FAIL;

  }



  return OCI_SUCCESS;

}