What are stored procedures? How to call them?
- 3 Answers
- 5459 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What will happen when ResultSet is not closed?
Explain the locking system in jdbc & its types?
What is the function of setautocommit?
What is jdbc and jdbc drivers?
How do I know which jdbc driver to use?
Is the JDBC-ODBC Bridge multi-threaded?
What are static and dynamic queries?
What is the difference between Union, Unionall ?
What is Type-4 Driver and when this driver is used?
Explain the different ways to register a driver?
What is jndi lookup?
What does the jdbc resultsetmetadata interface?
Core Java 
