skip to main content
Interface Provider class : IP methods reference : ipProcedure
 

ipProcedure

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 Chapter 4 of the OpenAccess SDK SQL Engine Programmer’s Guide for more information.
int ipProcedure(
int64 hstmt,
int iType,
out long piNumResRows)
 
 
Table 26: 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 

• ipGetSupport