---
title: "Call Function - ODBC 驱动程序  V2.0.8 | OceanBase 文档中心"
description: "Call Function OceanBase Connector/ODBC 支持 Call Function 命令，语法如下： {call func_name()} Call Function 命令在实际的执行过程中会转换成如下语句： BEGIN func_name() END; 示例如下： ODBC_TEST(t…"
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*0V2BT7xsMSQAAAAAAAAAAAAADiGDAQ/original) ODBC 驱动程序 V 2.0.8

# Call Function

更新时间：2026-04-09 15:10:59

[编辑](https://github.com/oceanbase/connector-odbc-doc/edit/V2.0.8/zh-CN/300.user-guide/500.call_function.md)  

OceanBase Connector/ODBC 支持 Call Function 命令，语法如下：

```sql
{call func_name()}

```

Call Function 命令在实际的执行过程中会转换成如下语句：

```sql
BEGIN
func_name()
END;

```

示例如下：

```sql
ODBC_TEST(test_func_normal)
{
  SQLRETURN ret = 0;
  SQLLEN outLen = 0;
  char *createpl = "create or replace function query_bench(str in varchar2) RETURN varchar2 IS\n"
    " l_rst    varchar2(100);\n"
    "begin\n"
    "  l_rst:='1234455';\n"
    "  RETURN l_rst;\n"
    "end query_bench;";

  CHECK_STMT_RC(Stmt, ret = SQLPrepare(Stmt, (SQLCHAR*)createpl, (SQLINTEGER)strlen((char*)createpl)));
  CHECK_STMT_RC(Stmt, ret = SQLExecute(Stmt));
  CHECK_STMT_RC(Stmt, ret = SQLFreeStmt(Stmt, SQL_CLOSE));
  SQLEndTran(SQL_HANDLE_DBC, Connection, SQL_COMMIT);

  SQLRETURN rcode;
  char *pCall = (char*)"{ ? = call QUERY_BENCH(?)}";
  char buf1[100] = { 0 };
  char buf2[100] = { 0 };
  SQLLEN inOut = SQL_NTS;

  rcode = SQLPrepare(Stmt, (SQLCHAR*)pCall, strlen(pCall));
  CHECK_STMT_RC(Stmt, rcode);
  rcode = SQLBindParameter(Stmt, 1, SQL_PARAM_OUTPUT, SQL_C_CHAR, SQL_CHAR, 0, 0, buf1, 100, &inOut);
  rcode = SQLBindParameter(Stmt, 2, SQL_PARAM_OUTPUT, SQL_C_CHAR, SQL_CHAR, 0, 0, buf2, 100, &inOut);
  rcode = SQLExecute(Stmt);
  CHECK_STMT_RC(Stmt, rcode);
  printf("buf2=%s\n", buf1);
  return OK;
}

```

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线