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 jdbc architecture?
How can I connect mysql or oracle with java?
What is odbc and jdbc in dbms?
How can I determine where a given table is referenced via foreign keys?
Can I get a null resultset?
What are types of jdbc drivers?
Discuss the procedure of retrieving warnings?
What is the function of setautocommit?
Why did my jdbc code throw a rollback sqlexception?
What is the JDBC?
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
Is jdbctemplate thread safe?
What causes no suitable driver error?
any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.
What are the three parts of a jdbc url?