Interested to Buy Any Domain ? << Click Here >> for more details...
what is callable statement?
- 6 Answers
- 23305 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 does the jdbc resultset interface?
Explain the different ways to register a driver?
How to connect html page to database using jdbc?
What is Type-4 Driver and when this driver is used?
What is 2 phase commit?
Explain about Join?
How to get a whole row of data at once?
Give an example for execution of sql statement.
What is drivermanager in jdbc?
Prepared statements are faster. Why?
write down exceptions those appear in java programs when u write JDBC Programs?
What is metadata in jdbc?
Core Java 
