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 |
Which type of JDBC driver is the fastest one?
How do java applications access the database using jdbc?
What are the flow statements of jdbc?
How is jndi useful for Database connection?
What is data source in java?
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
What is phantom read and which isolation level prevents it?
How many rowset are available in jdbc?
all Java qts are imp ?
What are the differences between setmaxrows(int) and setfetchsize(int)?
What does executequery return in java?
What are the different types of classes in the api component?