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 the difference between SENSITIVE and INSENSITIVE?
What is new in JDBC 2.0?
What is jdbc and its types?
What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?
What is a connection string used for?
What types of DataSource objects are specified in the Optional Package?
what is the meaning of following code snippets Class c=class.forName(driverClassName); Driver d=(driver)c.newInstance();
In which ways is driver class is registered with drive manager?
How do I know which jdbc driver to use?
Explain how to make updates to the updatable resultsets.
Which Java and java.sql data types map to my specific database types?
What is Connection Pooling ??? How we set up a particular connection within connection pooling ????