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 jdbc architecture?

1085


How can I connect mysql or oracle with java?

1010


What is odbc and jdbc in dbms?

1010


How can I determine where a given table is referenced via foreign keys?

1056


Can I get a null resultset?

1086


What are types of jdbc drivers?

1037


Discuss the procedure of retrieving warnings?

1032


What is the function of setautocommit?

1307


Why did my jdbc code throw a rollback sqlexception?

963


What is the JDBC?

1157


How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?

1105


Is jdbctemplate thread safe?

968


What causes no suitable driver error?

1015


any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.

2355


What are the three parts of a jdbc url?

1078