aspose file tools*
The moose likes JDBC 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
Bookmark "Handling Cursors in JDBC programming" Watch "Handling Cursors in JDBC programming" New topic
Author

Handling Cursors in JDBC programming

Rajaguru Ramalingam
Greenhorn

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: 1081

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

Shailesh


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