Interested to Buy Any Domain ? << Click Here >> for more details...
what is callable statement?
- 6 Answers
- 23316 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 exactly happens when we execute "Class.forname("Driver class name");"?Explain indetail
10 Answers Accenture, HP, IBM, Infosys, SAP Labs, SAS, Sasken, Trigent, Wipro,
Is possible to open a connection to a database with exclusive mode with JDBC?
How do you debug PL/SQL code?
Which jdbc drivers will run your program?
Explain some new features available in jdbc 4.0?
Can I get a null resultset?
What is jdbc databasemetadata interface?
What is the exception thrown by JDBC ?
How many packages are available in jdbc api?
What is jdbc and jdbc drivers?
What type of drivers have you used?
What is execute in java?
Core Java 
