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 |
What are the advantages of collection pools?
What do you understand by jdbc driver and explain its types?
What are devices?
What is the meaning of “dirty read” in the database?
Does jdbctemplate close connection?
What is the function of drivermanager class?
What are the basic exceptions in jdbc?
Explain some new features available in jdbc 4.0?
what are the drawbacks of JDBC? explain briefly?
What is connection pooling? What Method and class used for Connection pooling in Java?
How to set NULL values in JDBC PreparedStatement?
What is jdbc odbc connection?