Frees all resources (local and remote) associated with a result set. In some cases (e.g., very large result sets) this can be a critical step to avoid exhausting resources (memory, file descriptors, etc.)

Methods in other packages

  • DatabaseConnector::dbClearResult("DatabaseConnectorResult")

# S4 method for DatabaseConnectorResult
dbClearResult(res, ...)



An object inheriting from DBIResult.


Other arguments passed on to methods.


dbClearResult() returns TRUE, invisibly, for result sets obtained from both dbSendQuery()

and dbSendStatement(). An attempt to close an already closed result set issues a warning in both cases.