Oracle 8i Cursors via JDBC

Does anybody have samples of how to use JDBC calls to work with a cursor on Oracle 8i? Can it even be done?

I'd like to be able to do something like:

String sql = "DECLARE CURSOR my_cursor FOR SELECT name,id FROM name_tbl";
statement.execute(sql); (executeQuery? executeUpdate?) ...
while(...)
{
  String query = "FOR 100 FETCH my_cursor";   ResultSet rs = statement.executeQuery(query);
// process up to 100 rows in another loop and then fetch 100 more
// how do I know when the cursor has run out of rows versus just
// the ResultSet running out of its rows (do I just try again as
long
// as I get 100 rows in ResultSet or is there something else that
tells me?
}

Thanks,
David Received on Thu Oct 30 2003 - 02:59:57 CET