Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

ipProcedure

  • Last Updated: May 12, 2026
  • 1 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

If you want the IP to support stored procedure calls that return a single result set, implement this method in your IP. The OpenAccess SDK SQL engine passes stored procedure calls to this method for procedures that return, at most, a single pre-defined result set. Stored procedure calls are invoked using the ODBC stored procedure invocation syntax.

ipGetSupport should return true for IP_SUPPORT_PROCEDURE.

Refer to Stored Procedure Processing in the DataDirect OpenAccess SDK Programmer's Guide for more information.

int ipProcedure(
    long   hstmt,
    int    iType,
    xo_long piNumResRows)

Parameters for ipProcedure

Parameter Type Description
INPUT
hstmt long The statement handle of the currently active statement.
iType int Type of operation requested:
  • DAM_PROCEDURE - execute the stored procedure and return the first set of rows or all the rows. If the IP is written to work in cursor mode, return DAM_SUCCESS_WITH_RESULT_PENDING after returning a block of rows.
  • DAM_FETCH - get next set of rows. Return DAM_SUCCESS_WITH_RESULT_PENDING when more rows are pending. Return DAM_SUCCESS when completed.
  • DAM_CLOSE - cleanup processing of the stored procedure.
  • piNumResRows xo_long The number of rows affected by this operation.
    RETURN
    int DAM_SUCCESS - on success
    DAM_FAILURE - on failure

    See also

    TitleResults for “How to create a CRG?”Also Available inAlert