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 does adapter class provide?

599


How can I use the JDBC API to access a desktop database like Microsoft Access over the network?

621


What protocol does jdbc use?

603


Explain about column name and getter method?

684


What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?

603






Which is faster jdbc or odbc?

576


What are the advantages of database connection pooling?

566


Explain the difference between rowset vs. Resultset in jdbc?

670


How do I find jdbc version?

624


What is hbm xml?

572


Give steps to connect to the db using jdbc?

672


Can we return resultset in java?

563


What is the use of the statement in jdbc?

576


How to check jdbc connection in java?

579


What are devices?

586