how to use CallableStatement?
specially how to use their index given ..



how to use CallableStatement? specially how to use their index given ....

Answer / suresh

CallableStatement object is used to call the stored
procedure and stored procedure is nothing but it's block of
code and it's identified unique name

ex

CallableStatement cs=con.prepareCall();
cs.executeUpdate(Call"{procedure name}");


con is a Connection object
It has three parameter

IN
OUT
INOUT

IN parameter used to store any value to stored procedure
using setXX() method..

OUT parameter used to get the information or values from the
stored procedure using getXX() method,that object to
registered using registerOutParameter()

INOUT used to both store and get the information...

Is This Answer Correct ?    7 Yes 1 No

Post New Answer

More JDBC Interview Questions

What does jdbc stand for?

0 Answers  


Describe the steps needed to execute a sql query using jdbc.

0 Answers  


What is an outer join?

3 Answers   Infogain,


What is getconnection method in java?

0 Answers  


What is a PreparedStatement?

3 Answers   Infosys,


What is the role of class.forname while loading drivers?

0 Answers  


What do you mean by batch processing in jdbc?

0 Answers  


What is jdbc odbc bridge?

0 Answers  


What is difference between jdbc and odbc?

0 Answers  


What are the utilities of the callablestatement?

0 Answers  


Difference between Generic Servlet and HTTP Servlet?

13 Answers  


Can resultset be null in java?

0 Answers  


Categories