Interested to Buy Any Domain ? << Click Here >> for more details...
What are stored procedures? How to call them?
- 3 Answers
- 6089 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 |
Hi friends, In JDBC 4 drivers are there among this which driver is best and why it is best.Which driver is most commonly used in web applications.
How can a java objects be stored in database?
What does setautocommit do?
How to update a resultset programmatically?
What are the 4 types of jdbc drivers?
What does jdbc do?
What is jdbc and jdbc drivers?
What is resultset in jdbc with example?
What is the JDBC syntax for using a literal or variable in a standard Statement?
Explain the importance of drivermanager.
What does executeupdate return in jdbc?
Difference between Dirty, commited ,phantom,repeatable reads?
Core Java 
