jQuery in Action, 3rd edition
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: http://aspose.com/file-tools
subject: Handling Cursors in JDBC programming
It's not a secret anymore!