skip to main content
Interface Provider class : ipProcedure
 

ipProcedure

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 Chapter 4 of the DataDirect OpenAccess SDK SQL Engine Programmer's Guide for more information.
int ipProcedure(
    long   hstmt,
    int    iType,
    xo_long piNumResRows)
Table 24. 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

*ipGetSupport