Interested to Buy Any Domain ? << Click Here >> for more details...
What are stored procedures? How to call them?
- 3 Answers
- 6134 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 is the difference between ojdbc6 and ojdbc7?
What is the difference between triggers and procedures?
What is preparedstatement in jdbc?
Is jdbc part of j2ee?
What are the common tasks of JDBC?
What is database deadlock ?
What is jdbc and its types?
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
What is the use of getGeneratedKeys() method in Statement?
can we define indexes on a foreign key? Explain pros and cons?
How is database middleware used to access legacy databases?
How many ways can you update a result set?
Core Java 
