Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Why did my jdbc code throw a rollback sqlexception?

857


How do I find whether a parameter exists in the request object?

862


Is there another way of dealing with the result set that could execute faster?

964


What is jdbc dialect?

867


Name different methods for getting streams.

926


How do we call a stored procedure from jdbc?

922


What is connection commit?

879


What is JDBC Savepoint? How to use it?

1132


Why is odbc needed?

864


What are the advantages of using preparedstatement over statement?

937


What is a java driver?

933


What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?

932


What are the classes and methods used for sending sql statements to database?

1012


What is jdbc odbc?

940


How many locking systems are there in jdbc?

965