oci 字段信息

最新推荐文章于 2024-08-30 21:57:09 发布

qiuleng2002

最新推荐文章于 2024-08-30 21:57:09 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏：技术（WINDOWS）文章标签： descriptor

本文链接：https://blog.youkuaiyun.com/qiuleng2002/article/details/3497874

技术（WINDOWS）专栏收录该内容

7 篇文章

订阅专栏

本文介绍如何使用OCI (Oracle Call Interface) 获取SQL语句中选择列表的位置参数。通过 OCIParamGet 和 OCIAttrGet 函数来获取参数的数据类型、列名及数据大小。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

OCIParam     *mypard;
     ub4          counter;
     ub2          dtype,deptlen;
     text         *col_name;
     ub4          col_name_len;
     sb4          parm_status;
     /* Request a parameter descriptor for position 1 in the select-list */

     counter = 1;
parm_status = OCIParamGet(stmthp, OCI_HTYPE_STMT, errhp, (dvoid **)&mypard,
        counter);
/* Loop only if a descriptor was successfully retrieved for
    current position, starting at 1 */
while (parm_status==OCI_SUCCESS) {
  /* Retrieve the data type attribute */
  error_proc(errhp, OCIAttrGet((dvoid*) mypard, (ub4) OCI_DTYPE_PARAM,
       (dvoid*) &dtype,(ub4 *) 0, (ub4) OCI_ATTR_DATA_TYPE,
      (OCIError *) errhp ));
  /* Retrieve the column name attribute */
  error_proc(errhp, OCIAttrGet((dvoid*) mypard, (ub4) OCI_DTYPE_PARAM,
      (dvoid**) &col_name,(ub4 *) &col_name_len, (ub4) OCI_ATTR_NAME,
      (OCIError *) errhp ));

  /* Retrieve the column data size */
  error_proc(errhp, OCIAttrGet((dvoid*) mypard, (ub4) OCI_DTYPE_PARAM,
        (dvoid*) &deptlen, (ub4 *) 0, (ub4) OCI_ATTR_DATA_SIZE,
        (OCIError *) errhp ));

  printf("column=%s datatype=%d   datasez=%d/n/n", col_name, dtype,deptlen);
  fflush(stdout);
  /* increment counter and get next descriptor, if there is one */
  counter++;
  parm_status = OCIParamGet(stmthp, OCI_HTYPE_STMT, errhp, (dvoid **)&mypard, counter);
}