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.
posted 14 years ago
You'd probably get better response in the JDBC forum. I'm moving this there.