oracle的pro*c语法 调用函数包含入参 接受返回值的代码用例

以下是 Oracle Pro*C 调用函数，包含入参和接受返回值的代码示例：

#include <stdio.h>
#include <sqlca.h>
#include <oraca.h>
#include <oci.h>

void check_err(OCIError *errhp)
{
    sb4 errcode = 0;
    text errbuf[512];
    memset(errbuf, 0, sizeof(errbuf));
    OCIErrorGet((dvoid *)errhp, (ub4)1, (text *)NULL, &errcode,
                errbuf, (ub4)sizeof(errbuf), OCI_HTYPE_ERROR);
    printf("Error - %s\n", errbuf);
}

int main()
{
    /* 初始化环境 */
    OCIEnv *envhp;
    OCIError *errhp;
    OCIServer *srvhp;
    OCISvcCtx *svchp;
    OCISession *authp;
    OCIStmt *stmthp;
    sword status;

    status = OCIEnvCreate((OCIEnv **)&envhp, OCI_DEFAULT, (dvoid *)0,
                          (dvoid * (*)(dvoid *, size_t))0,
                          (dvoid * (*)(dvoid *, dvoid *, size_t))0,
                          (void (*)(dvoid *, dvoid *))0, (size_t)0, (dvoid **)0);
    if (status != OCI_SUCCESS)
    {
        printf("OCIEnvCreate failed\n");
        return -1;
    }

    status = OCIHandleAlloc((dvoid *)envhp, (dvoid **)&errhp, OCI_HTYPE_ERROR,
                            (size_t)0, (dvoid **)0);
    if (status != OCI_SUCCESS)
    {
        printf("OCIHandleAlloc (error handle) failed\n");
        return -1;
    }

    /* 连接数据库 */
    status = OCIHandleAlloc((dvoid *)envhp, (dvoid **)&srvhp, OCI_HTYPE_SERVER,
                            (size_t)0, (dvoid **)0);
    if (status != OCI_SUCCESS)
    {
        printf("OCIHandleAlloc (server handle) failed\n");
        return -1;
    }

    status = OCIServerAttach(srvhp, errhp, (text *)"", strlen(""), 0);
    if (status != OCI_SUCCESS)
    {
        check_err(errhp);
        return -1;
    }

    status = OCIHandleAlloc((dvoid *)envhp, (dvoid **)&svchp, OCI_HTYPE_SVCCTX,
                            (size_t)0, (dvoid