D.19 HS_FDS_RSET_RETURN_ROWCOUNT

HS_FDS_RSET_RETURN_ROWCOUNT initialization parameter for Oracle Database Gateway for SQL Server.

Property Description

Default Value

FALSE

Range of values

{TRUE|FALSE}

Syntax

HS_FDS_RSET_RETURN_ROWCOUNT= {TRUE|FALSE}

When set to TRUE, the gateway returns the row counts of DML statements that are executed inside a stored procedure. The row count is returned as a single row, single column result set of type signed integer.

When set to FALSE, the gateway skips the row counts of DML statements that are executed inside a stored procedure. This is the default behavior, and it is the behavior of 11.1 and older gateways.