Answer Posted / hazarath k

Stored Procedure is a set of precompiled SQL statements
(i.e., ready for execution), which will be executed at
Database server(backend).
By using the Callable Statement,We can call the Stored
Procedure from front-end.Callable is an interface.Every
vendor can provide their own implementation classes for
this intercace.By using this Callable Statement, we can
call the Stored Procedure/Stored Function.

Ex/Syntax:
Connection con=DriverManager.getConnection("---
","UID","PWD");
CallableStatement cstmt=con.prepareCall('{call
ProcedureName}');

What is jdbc driver manager?

899

---

What are the different types of lockings in jdbc?

855

---

Explain about column name and getter method?

1008

---

How do I insert an image file (or other raw data) into a database?

917

---

How a database driver can be loaded with jdbc 4.0 / java 6?

890

---

What causes the "No suitable driver" error?

970

---

What is an odbc driver?

855

---

What happens if connection is not closed in jdbc?

908

---

What is benefit of using preparedstatement in java?

861

---

What is jdbc odbc in java?

983

---

What is jdbc template?

911

---

What is the difference between executing, executequery, executeupdate in jdbc?

952

---

What is odbc. how is it related to sql cli?

981

---

What is metadata in jdbc?

916

---

Explain the necessary steps to connect to the database in java?

981

---