Hi to all...
Suppose I have a stored procedure that makes an update AND a query that gives back a resultset.
Suppose I have to call this stored procedure by Java JDBC.
How can I execute the update and retrieve the resultset?
If I use executeUpdate(), I'll get back an int; if I use executeQuery(), I'll get back a resultset, but will the update part be processed?
You should be using: java.sql.CallableStatement.
Use executeQuery to get the Result Set. Have the update process return its result using an OUT parameter of the SP. YOu can then get the value of the OUT parameter after the call to the executeQuery.