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

Why would you use setautocommit(false) in jdbc?

1206


What is the full form of jdbc?

1030


Explain creation of statement object with connection method create method with help of an example.

977


What are the types of statements in jdbc?

986


What are dml and ddl?

1002


What is jdbc and why is it required?

925


What does jdbc do?

1040


What is encrypted connection?

1011


What are the measures to connect to the db using jdbc?

1041


Briefly tell about the jdbc architecture.

998


How does a custom RowSetReader get called from a CachedRowSet?

1087


How we can you use preparedstatement.

969


How does jdbc driver work?

984


What is a lock in jdbc?

957


How do I set properties for a JDBC driver and where are the properties stored?

966