This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Java in General and the fly likes java and jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "java and jdbc" Watch "java and jdbc" New topic
Author

java and jdbc

Chanpreet Julka
Ranch Hand

Joined: Nov 09, 2001
Posts: 40
I am trying to execute a stored procedure in a database using the prepareCall method. This is how I use it to call a procedure passing two paramters.
connect.prepareCall("call procedure[(?,?)]}");
How do I change this if my procedure does not pass in any parameters but returns two parameters. I want to also go through a loop and assign what is returned to variables. THe first thing returned is a string, and the second argument returned is a float. Thank you.
Carl Trusiak
Sheriff

Joined: Jun 13, 2000
Posts: 3340
You'd probably get better response in the JDBC forum. I'm moving this there.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java and jdbc
 
Similar Threads
@NamedNativeQuery and choosing the correct resultClass
How resultset is returned by stored procedure?
Executing stored procedures in hibernate
java and jdbc
sql server callable statement result set issue..