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