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.