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

What is the most common example type 1 driver?

1029


What causes the "No suitable driver" error?

1059


What is resultsetmetadata?

904


Why are we using blob datatypes in jdbc?

1086


Why should we close database connections in java?

1145


What is jdbc databasemetadata interface?

1052


Which interface is responsible for transaction management in jdbc?

1023


What are temp tables ?

980


What is the limitation of PreparedStatement and how to overcome it?

1145


What is a merge field?

937


What is the JDBC?

1080


Explain jdbc savepoint?

974


How to check jdbc connection in linux?

1031


Differentiate between type_scroll_insensitive and type_scroll_sensitive.

923


Is odbc an api?

1039