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 is jdbc and jdbc drivers?

0 Answers  


What is the exception thrown by JDBC ?

7 Answers  


How do find debugging problems related to JDBC API?

1 Answers  


What is the latest version of JDBC? What are the new features added in that?

0 Answers  


Differentiate between a statement and a preparedstatement.

0 Answers  






Does sql allow null values ?

0 Answers  


What is the jdbc rowset?

0 Answers  


Which jdbc driver is the fastest driver?

0 Answers  


What is url in jdbc connection?

0 Answers  


How do I start debugging problems related to the JDBC API?

0 Answers  


What is the difference between ojdbc6 and ojdbc7?

0 Answers  


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

0 Answers  


Categories