JDBC Stored Procedure Returns OUT Parameters In Java
Chapter:
JDBC
Last Updated:
23-06-2016 19:32:58 UTC
Program:
/* ............... START ............... */
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Types;
public class JavaJDBCReturnOutParameter {
public static void main(String a[]) {
Connection connection = null;
CallableStatement callSt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
connection = DriverManager.getConnection("jdbc:oracle:thin:@<hostname>:"
+ "<port num>:<DB name>", "user",
"password");
callSt = connection.prepareCall("{call myprocedure(?,?)}");
callSt.setInt(1, 200);
// below method used to register data type of the out parameter
callSt.registerOutParameter(2, Types.DOUBLE);
callSt.execute();
Double output = callSt.getDouble(2);
System.out.println("The output returned from stored procedure: " + output);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if (callSt != null)
callSt.close();
if (connection != null)
connection.close();
} catch (Exception ex) {
}
}
}
}
/* ............... END ............... */
Notes:
-
A CallableStatement object provides a way to call stored procedures using JDBC.
- Connection.prepareCall() method provides you CallableStatement object.
Tags
JDBC Stored Procedure Returns OUT Parameters, Java