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
Explain the process of creating tables using NetBeans IDE?
What is java soft framework?
code to insert values/rows into oracle database from a java swing textfield when a button is pressed(using preparedstatements)
What is a statement in java?
What are the different types of drivers under jdbc?
Can we have foreign key reference to a non primary key column ?
Why do you use a data source object for a connection?
What is the role of jdbc drivermanager class?
What is two-phase commit in the database?
What is jdbc odbc connection?
How to insert an image or raw data into database?
Where is mysql jdbc driver located?
What is savepoint in jdbc?
What is jdbc and odbc?
What is while rs next ())?