Interested to Buy Any Domain ? << Click Here >> for more details...
what is callable statement?
- 6 Answers
- 23547 Views
- Infogain, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harish
the JDBC Callable statement provides a mechanism to call
stored procedures in a standardized,database independent
way. The JDBC callable statement hides the differences in
stored procedure implementation,execution and parameter
handling from Java applications.
| Is This Answer Correct ? | 46 Yes | 5 No |
Answer / devarathnam c,kotagudibanda(po
Hi... CallableStatement : It is an interface in JDBC
API,which can be used to calling the storedprocedures and
functions in backend like oracle,sybase.
Syntax:
CallableStatement cst=con.prepareCall("{call <procedure
name>(?,?)}");
| Is This Answer Correct ? | 34 Yes | 6 No |
Answer / sanjeev gupta
Callable Statemnt Example:- Here we prsent a stored
procedure fetuser(int userid) taht takes user id as
parameter and returns the first_name and last_name column
of the user.
try {
CallableStatement callablestmt =
con.prepareCall("{call fetchuser(?)}");
callablestmt.setInt(1,1);
ResultSet rs1 = callablestmt.executeQuery();
while(rs1.next())
{
String fname = rs1.getString("FIRST_NAME");
String lname = rs1.getString("LAST_NAME");
out.println(fname+" "+lname+ "<br />");
}
} catch (SQLException e) {
e.printStackTrace();
}
| Is This Answer Correct ? | 21 Yes | 6 No |
Answer / manojkumar.l
It's using for execute stored procedure and also execute
multiple select statement
| Is This Answer Correct ? | 15 Yes | 7 No |
Answer / chandrarekha
connection statement provides the preparecall() method
which is used to create callabale statement....and it's
derived from the prepared statement interface...it can be
used to create stored procedures or to use the existing
stored procedures
| Is This Answer Correct ? | 19 Yes | 12 No |
Answer / bama
the JDBC Callable statement provides a mechanism to call
stored procedures in a standardized,database independent
way. The JDBC callable statement hides the differences in
stored procedure implementation,execution and parameter
handling from Java applications.
| Is This Answer Correct ? | 6 Yes | 5 No |
What is the advantage of namedparameterjdbctemplate?
What are different types of ResultSet?
What are the jdbc drivers in java?
How we store procedure in oralce for callable statements in jdbc
Without using of Class.forName(? ?), how do you connect to db?
Why do we need a jdbcrowset like wrapper around resultset?
How can I connect mysql or oracle with java?
What is the use of JDBC DriverManager class?
what are the drawbacks of JDBC? explain briefly?
How transactions are performed using JDBC ?
How does jdbc connect to database?
How data can be inserted into long row column of database?
Core Java 
