Forums Register Login

Handling Cursors in JDBC programming

+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
Register your out paramter as cursor, execute the procedure then typecast your output cursor to resultset and use onwards

Shailesh
Be reasonable. You can't destroy everything. Where would you sit? How would you read a tiny ad?
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 989 times.
Similar Threads
Error in row
Connections that won't close
what is difference between JDBC1 and JDBC2 ?
ClassNotFoundException
Invalid Cursor State Error...
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 19:14:39.