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...

What are stored procedures? How to call them?

Answer Posted / hazarath k

Stored Procedure is a set of precompiled SQL statements
(i.e., ready for execution), which will be executed at
Database server(backend).
By using the Callable Statement,We can call the Stored
Procedure from front-end.Callable is an interface.Every
vendor can provide their own implementation classes for
this intercace.By using this Callable Statement, we can
call the Stored Procedure/Stored Function.

Ex/Syntax:
Connection con=DriverManager.getConnection("---
","UID","PWD");
CallableStatement cstmt=con.prepareCall('{call
ProcedureName}');

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of collection pools?

1021


Name different methods for getting streams.

962


What is jdbc driver manager?

922


What is a JDBC 2.0 DataSource?

960


What is JDBC Savepoint? How to use it?

1187


What is jdbc odbc connection?

960


What are the three parts of a jdbc url?

999


What is the reason why we need a jdbcrowset like the wrapper around resultset?

957


What are the components of jdbc?

968


What is a jdbc connection string?

918


What is jdbc in java?

907


Explain the life cycle of jdbc.

1020


What is odbc and jdbc in dbms?

942


Is possible to open a connection to a database with exclusive mode with JDBC?

954


How does a file store compare with a jdbc store?

1175