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 causes the "No suitable driver" error?
Which database is used with java?
Without using of Class.forName(? ?), how do you connect to db?
What is use of connection pooling?
RowSetInternal caller and returns void. What can I do in the readData method?
Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?
Differentiate between a statement and a preparedstatement.
What is jdbc connection?
What does setautocommit do?
What is sqlwarning?
What is the jdbc rowset?
How do java applications access the database using jdbc?