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

ipProcedureDynamic

If your IP is to support stored procedure calls which return one or more results sets that are defined at runtime, you must implement this method in your IP. The OpenAccess SDK SQL Engine passes stored procedure calls to this method for all stored procedures marked in the schema as supporting results defined at run-time.
Stored procedure calls are invoked using the ODBC stored procedure invocation syntax. ipGetSupport should return true for IP_SUPPORT_PROCEDURE.
int ipProcdureDynamic(
int64 hstmt,
int iType,
out long piNumResRows)
 
Table 27: Parameters for ipProcedureDynamic 
Parameter
Type
Description
IN
 
 
hstmt
int64
The statement handle of the currently active statement.
iType
int
Type of operation requested:
DAM_DSP_INIT – initialize
DAM_DSP_EXECUTE – Execute the stored procedure and return either all or first block of rows from the current result set. If you designed your IP to work in cursor mode, then return DAM_SUCCESS_WITH_RESULT_PENDING after returning a block of rows.
DAM_FETCH – Get next set of rows form the current result set. Return DAM_SUCCESS_WITH_RESULT_PENDING when more rows are pending. Return DAM_SUCCESS when completed.
DAM_CLOSE – Cleanup processing of the current result set.
OUT
 
 
piNumResRows
long
The number of rows affected by this operation.
RETURN
 
 
 
int
DAM_SUCCESS – on success
DAM_FAILURE – on failure
DAM_SUCCESS_WITH_MORE_RESULT_SETS – more results available.