File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Return Value from Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Return Value from Stored Procedure" Watch "Return Value from Stored Procedure" New topic

Return Value from Stored Procedure

Patrick Mugabe
Ranch Hand

Joined: Jan 08, 2002
Posts: 132
I have a stored procedure with an out parameter so I think it should return a value (correct me if I am wrong). I am calling the stored procedure in my java program.
How do I get the value to my java program. I want to use the returned value in another operation.
Brian Mozhdehi
Ranch Hand

Joined: Aug 17, 2006
Posts: 81
You need to do the following.

Assume stmt is the CallableStatement object that is returned from prepareCall() and all input has been set.

stmt.registerOutParameter(<the position of the output parameter>, java.sql.Types.<whatever type it is>);

Then, after execution:

String value = stmt.getString(<the position of the output parameter>);

or whatever type it is, i.e. stmt.getInt(), etc.

Hope that helps.
I agree. Here's the link:
subject: Return Value from Stored Procedure
It's not a secret anymore!