Oracle 8i Cursors via JDBC
From: David (d.wall_at_computer.org)
Date: 10/30/03
- Next message: bevyn quiding: "jboss and ingres"
- Previous message: Dave Bender: "Re: JDBC to Ingres Woessss...."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 29 Oct 2003 17:57:54 -0800
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
- Next message: bevyn quiding: "jboss and ingres"
- Previous message: Dave Bender: "Re: JDBC to Ingres Woessss...."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
