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 |
When do we use execute method in java jdbc?
Are all the required JDBC drivers to establish connectivity to my database part of the JDK?
Diff. types of triggers..
What is jdbc odbc in java?
What is odbc and jdbc drivers?
How can you retrieve data from the resultset using jdbc?
What is a datasource in java?
What is the difference between client and server database cursors?
What type of driver you use in real-time projects?
What is metadata in programming?
what is call level interface?
what are the Different types of exceptions in JDBC?