What are stored procedures? How to call them?

Question Posted / guest

3 Answers
6228 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are stored procedures? How to call them?..

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

What are stored procedures? How to call them?..

Answer / guest

Stored procedures are stored programs in jdbc.pl/sql is a
stored procedure.they can be called from java by callable
statement.
CallableStatement st=con.prepareCall("{----}");

Is This Answer Correct ?

0 Yes

0 No

What are stored procedures? How to call them?..

Answer / subbu

A Stored procedure is a collection of sql statements that
are stored under a name & executed.when you create a stored
procedure all the steps like parsing,checking,compiling etc
are carried out.They can be called from java by using
prepareCall().

Is This Answer Correct ?

0 Yes

0 No

Post New Answer