how to use CallableStatement?
specially how to use their index given ..
Answer Posted / 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 View All Answers
Why did my jdbc code throw a rollback sqlexception?
How do I find whether a parameter exists in the request object?
Is there another way of dealing with the result set that could execute faster?
What is jdbc dialect?
Name different methods for getting streams.
How do we call a stored procedure from jdbc?
What is connection commit?
What is JDBC Savepoint? How to use it?
Why is odbc needed?
What are the advantages of using preparedstatement over statement?
What is a java driver?
What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?
What are the classes and methods used for sending sql statements to database?
What is jdbc odbc?
How many locking systems are there in jdbc?