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
What is the most common example type 1 driver?
What causes the "No suitable driver" error?
What is resultsetmetadata?
Why are we using blob datatypes in jdbc?
Why should we close database connections in java?
What is jdbc databasemetadata interface?
Which interface is responsible for transaction management in jdbc?
What are temp tables ?
What is the limitation of PreparedStatement and how to overcome it?
What is a merge field?
What is the JDBC?
Explain jdbc savepoint?
How to check jdbc connection in linux?
Differentiate between type_scroll_insensitive and type_scroll_sensitive.
Is odbc an api?