This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Callable Statement - Cursors Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Callable Statement - Cursors" Watch "Callable Statement - Cursors" New topic

Callable Statement - Cursors


Joined: Aug 05, 2002
Posts: 1
i am writing a stored procedure in DB2 which returns a resultset with values from different tables.
i want to access this stored procedure.How do i do it?( DB 2 users cursors to get the resultset)
Also should the cursor be left in open state in DB stored procedure?. Should i have the resultset as outparameter or will be directly be assigned to resultset when i execute the stored procedure from java application.
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Welcome to the Java Ranch, we hope you�ll enjoy visiting as a regular however,
your name is not in keeping with our naming policy here at the ranch. Please change your display name to an appropriate name as shown in the policy.
Thanks again and we hope to see you around the ranch!!

Consider Paul's rocket mass heater.
subject: Callable Statement - Cursors