ditto - stored procedure is just the ticket for this sort of problem. -----Original Message----- From: Bryan Hilterbrand [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 11:55 AM
There are many potential solutions to this, but one is to figure out what the end result of iterating through your result set is, then create a stored procedure to do the same thing. Bryan ----- Original Message ----- From: "Michael Lee" <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 9:42 AM Hey, do any of you [FRIDAY] guys know how to handle iterating through enourmously large result sets without storing the ResultSet object in memory? I use JDBC cursors now but have to do the query upon each 'next' or 'previous'. I always ask the tough questions that get few responses! :) Mike Lee -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>