c 执行oracle存储过程

对于C程序员来说，执行Oracle存储过程是常见需求之一，今天我们就来详细介绍如何通过C程序执行Oracle存储过程。

首先，我们需要连接到Oracle数据库。可以使用OCI库提供的函数进行连接，例如：

OCIEnv *envhp;
OCIError *errhp;
OCISvcCtx *svchp;
OCIStmt *stmthp;
OCIServer *srvhp;
OCIAuthInfo *auth;
OCIType *type;
OCIDefine *defnp;
OCIBind *bindp;
OCIErrorGet(&envhp, 0, (const OraText **)0, &errhp);
OCIHandleAlloc(envhp, (dvoid **)&srvhp, OCI_HTYPE_SERVER, 0, (dvoid **)0);
OCIHandleAlloc(envhp, (dvoid **)&auth, OCI_HTYPE_AUTHINFO, 0, (dvoid **)0);
OCIAttrSet(auth, OCI_HTYPE_AUTHINFO, (dvoid *)"username", (ub4)strlen("username"), OCI_ATTR_USERNAME, errhp);
OCIAttrSet(auth, OCI_HTYPE_AUTHINFO, (dvoid *)"password", (ub4)strlen("password"), OCI_ATTR_PASSWORD, errhp);
OCIAttrSet(auth, OCI_HTYPE_AUTHINFO, (dvoid *)"dbname", (ub4)strlen("dbname"), OCI_ATTR_DATABASE_NAME, errhp);
OCIHandleAlloc(envhp, (dvoid **)&svchp, OCI_HTYPE_SVCCTX, 0, (dvoid **)0);
OCIAttrSet(svchp, OCI_HTYPE_SVCCTX, (dvoid *)srvhp, (ub4)0, OCI_ATTR_SERVER, errhp);
OCIAttrSet(svchp, OCI_HTYPE_SVCCTX, (dvoid *)auth, (ub4)0, OCI_ATTR_AUTHINFO, errhp);
OCIHandleAlloc(envhp, (dvoid **)&stmthp, OCI_HTYPE_STMT, 0, (dvoid **)0);
OCILogon(envhp, errhp, &svchp, (OraText *)"username", strlen("username"), (OraText *)"password", strlen("password"), (OraText *)"dbname", strlen("dbname"));

连接成功后，我们需要通过OCIStmtPrepare函数准备存储过程的SQL语句：

char *sql = "begin my_procedue(); end;";
OCIStmtPrepare(stmthp, errhp, (const OraText *)sql, (ub4)strlen(sql), OCI_NTV_SYNTAX, OCI_DEFAULT);

注意，在SQL语句中需要指定存储过程的名称。如果存储过程需要参数，可以通过OCIBindByName函数绑定参数：

int arg1 = 10, arg2 = 20;
OCIBindByName(stmthp, &bindp, errhp, (const OraText *)":arg1", (sb4)strlen(":arg1"), (dvoid *)&arg1, (sb4)sizeof(int), SQLT_INT, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0, (ub4 *)0, OCI_DEFAULT);
OCIBindByName(stmthp, &bindp, errhp, (const OraText *)":arg2", (sb4)strlen(":arg2"), (dvoid *)&arg2, (sb4)sizeof(int), SQLT_INT, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0, (ub4 *)0, OCI_DEFAULT);

绑定参数后，我们可以调用OCIStmtExecute函数执行存储过程：

OCIStmtExecute(svchp, stmthp, errhp, (ub4)1, (ub4)0, (CONST OCISnapshot *)NULL, (OCISnapshot *)NULL, OCI_DEFAULT);

最后，我们需要通过OCIStmtFetch函数获取存储过程的结果：

int result;
OCINumber result_number;
OCIStmtFetch(stmthp, errhp, (ub4)1, OCI_FETCH_NEXT, OCI_DEFAULT);
OCINumberFromInt(errhp, &result, sizeof(result), OCI_NUMBER_SIGNED, &result_number);
OCINumberToInt(errhp, &result_number, sizeof(result), OCI_NUMBER_SIGNED, &result);
printf("Stored procedure returned %d\n", result);

上面的代码中，我们假设存储过程返回一个整数值。

总之，通过以上步骤，我们就可以轻松地在C程序中执行Oracle存储过程了。