Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java and jdbc

 
Chanpreet Julka
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You'd probably get better response in the JDBC forum. I'm moving this there.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic