skip to main content
DataDirect Connect XE Drivers : Salesforce Driver : Connection Properties : StmtCallLimit
  
StmtCallLimit
Purpose
Specifies the maximum number of Web service calls the driver can make when executing any single SQL statement or metadata query.
Valid Values
0 | x
where:
x
is a positive integer that defines the maximum number of Web service calls the driver can make when executing any single SQL statement or metadata query.
Behavior
If set to 0, there is no limit.
If set to x, the driver uses this value to set the maximum number of Web service calls on a single connection that can be made when executing a SQL statement. This limit can be overridden by changing the STMT_CALL_LIMIT session attribute using the ALTER SESSION statement. For example, the following statement sets the statement call limit to 10 Web service calls:

ALTER SESSION SET STMT_CALL_LIMIT=10
If the Web service call limit is exceeded, the behavior of the driver depends on the value specified for the StmtCallLimitBehavior property.
Default
20 (Web service calls)
Data Type
int