File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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
I agree. Here's the link:
subject: Handling Cursors in JDBC programming