How to call a Stored Procedure from JDBC?

Question Posted / gopalraop

4 Answers
6056 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to call a Stored Procedure from JDBC?..

Answer / vikneswarank

use callableStatment

Is This Answer Correct ?

2 Yes

0 No

How to call a Stored Procedure from JDBC?..

Answer / rama krishna dwadasi

By using CallableStatement we can call a stored Procedure
from JDBC

CallableStatement:- is an interface available in java.sql
package and is extending PreparedStatement interface.
•It is used to execute stored procedures available in the
database.
•Following is the way to create the CallableStatement object.
a)CallableStatement cs = con.prepareCall(sql);
b)CallableStatement cs = con.prepareCall(sql,int,int);
•One CallableStatement object can be used to invoke one
stored procedure only.
•CallableStatement also provides placeholder mechanism
•Following is the way to invoke the stored procedure.
CallableStatement cs = con.prepareCall(“{call p1 (?,?)}”);

Is This Answer Correct ?

3 Yes

2 No

How to call a Stored Procedure from JDBC?..

Answer / gajendra

We can use CallableStatement interface to call a stored
procedure.Use the following steps.

1. crate the escape syntax like
String sql="{call procname(?,?,?);
2.CallableStatement cst=con.prepareCall(sql);
3.Set the inparameters using setXXX methods like
cst.setInt(1,10);
cst.setString(2,"abc");
4.Register the out parameter
cst.registerOutParameter(1,Types.Float);
5.Submit the statement using
cst.execute();
6. We can get the data from stored procedure using getXXX
methods

Is This Answer Correct ?

4 Yes

4 No

How to call a Stored Procedure from JDBC?..

Answer / santosh kumar

by callable statement

Is This Answer Correct ?

0 Yes

0 No

Post New Answer