Interested to Buy Any Domain ? << Click Here >> for more details...
what is callable statement?
- 6 Answers
- 22987 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 are different types of ResultSet?
What is the exception thrown by JDBC ?
Which Driver is preferable for using JDBC API in Applets?
What are static and dynamic queries?
How a driver can be loaded?
I have getting problem to calling stored procedure from Mysql through JSP. Please help me.
What do you understand by jdbc driver and explain its types?
Is possible to open a connection to a database with exclusive mode with JDBC?
What is jdbc url for mysql?
How we say that PreparedStatment is Precompiled? where it will be compiled?
Is there another way of dealing with the result set that could execute faster?
Statement, PrepareStatement and Callable all these are interfaces. Thought it is a interface how come we are creating objects and calling methods("preparestatement()") in it. In which class this method is defined. Please let me know. Thanks in advance. example: PreparedStatement pre = con.prepareStatement( "UPDATE COFFEES SET SALES = ? WHERE COF_NAME LIKE ?");
Core Java 
