Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes JDBC and Relational Databases and the fly likes Handling Cursors in JDBC programming Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Handling Cursors in JDBC programming" Watch "Handling Cursors in JDBC programming" New topic

Handling Cursors in JDBC programming

Rajaguru Ramalingam

Joined: Apr 12, 2004
Posts: 11
Hi Everyone,

Assume, my Stored procedure returns 10 values of same type.If i din't keep that as array, i can use the cursor otherwise. If it is the case, how to handle the cursor which has values of same type in my java-jdbc programming?

Thanks in advance.
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1082

Register your out paramter as cursor, execute the procedure then typecast your output cursor to resultset and use onwards


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Consider Paul's rocket mass heater.
subject: Handling Cursors in JDBC programming