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 the IP is to support stored procedure calls that return one result set, you must implement this method in your IP. The OpenAccess SDK SQL Engine passes stored procedure calls to this method for procedures that will return, at most, one result set and the result set is pre-defined. 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 OpenAccess SDK SQL Engine Programmer’s Guide for more information.

int ipProcedure(
int64 hstmt,
int iType,
out long piNumResRows)

Parameters for ipProcedure

Parameter Type Description
IN    
hstmt int64 The statement handle of the currently active statement
OUT    
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 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