Oracle 8i Cursors via JDBC

[David]

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.execu te(sql); (executeQuery? executeUpdate?)
....
while(...)
{
String query = "FOR 100 FETCH my_cursor";
ResultSet rs = statement.execu teQuery(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