Pure JavaScript

Stproc.resultSet()

NES3+Syntax

							stproc.resultSet()

Description

The resultSet() object of the Stproc object creates a Resultset object for storing the results of running a stored procedure. For stored procedures run against DB2, Oracle, Sybase, and ODBC databases, the stored procedure object has one Resultset object for each SQL SELECT statement executed by the procedure. An Informix stored procedure, on the other hand, has one Resultset object.

Each instance of this object has a property for each column in the result set. For Oracle, Sybase, and ODBC stored procedures, these properties can be referred to by the column name. Informix and DB2 stored procedures do not have named columns, so you must use a zero-based numeric index to refer to ...