Specifies the maximum number of Web service calls the driver can make when executing any single SQL statement or metadata query.
Valid Values
-1 | 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 -1, the driver uses the default value that is configured in the service when connected to a site whose version is August 2014 or later. When connected to sites whose version is prior to August 2014, the driver sets the maximum number of calls to 100.
If set to 0, the driver uses the maximum number of calls allowed by the service when connected to a site whose version is August 2014 or later. When connected to sites whose version is prior to August 2014, there is no limit.
If set to x, the driver uses this value to set the maximum number of Web service calls that can be made when executing a SQL statement or metadata query.
The value specified for this connection property 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.
Additionally, if you specify a value that is greater than the maximum number of calls allowed when connected to a site whose version is August 2014 or later, the driver returns a warning that the setting exceeds the maximum value and uses the maximum value permitted.
