closed result set so database lockage should not occur