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 a site 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 a site 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 on a single connection that can be made when executing a SQL statement.
The value specified for this option 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 Stmt Call Limit Behavior option.
Additionally, If you specify a value that is greater than the maximum number of calls allowed when connecting to a site whose version is August 2014 or later, the driver uses the service defined maximum instead of the value specified.
