August 1999
Intermediate to advanced
1488 pages
72h 53m
English
resultset.close()
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.
Listing 8.112 creates a result set and then closes it.
<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(); ... |
Read now
Unlock full access