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 is in term of jdbc a datasource?
Why do we need a jdbcrowset like wrapper around resultset?
What causes the "No suitable driver" error?
What are the main components of JDBC ?
What is xe in oracle jdbc url?
How to make updates to updatable result sets in jdbc?
Why do we use jdbc?
Diff bet.. Function and Trigger?
Does jdbc use ssl?
What does the connection object represents?
What is ODBC and JDBC? How do you connect the Database?
What isolation level is used by the DBMS when inserting, updating and selecting rows from a database?