Resultset.close()

NES3+Syntax

							resultset.close()

Description

The close() method of the Resultset object closes the result set and frees all memory used to store its information. If successful, the method returns 0; otherwise, it returns an error code that can be obtained by using the majorErrorCode() and majorErrorMessage() methods of the Connection or database objects.

Example

Listing 8.112 creates a result set and then closes it.

Listing 8.112 Closing a Cursor with the close() Method
 <SERVER> // Open a connection var myConn = database.connect("ORACLE", "mySID", "myApp", "appsPWD", "myTNS"); myConn.beginTransaction(); // Run the stored procedure var myStproc = myConn.storedProc("sp_employees"); // Store the result set myResultSet = myStproc.resultSet(); ...

Get Pure JavaScript now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.