Interested to Buy Any Domain ? << Click Here >> for more details...
What are stored procedures? How to call them?
- 3 Answers
- 6395 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 |
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?
How do I receive a ResultSet from a stored procedure?
How do you debug PL/SQL code?
What is Normalization?
4 Answers Accenture, Atos Origin,
Is jpa faster than jdbc?
How do I find jdbc version?
How to create Connection interface object because it is Interface , Interface is not instansiated?
What is JDBC PreparedStatement?
When do we get java.sql.SQLException: No suitable driver found?
What is database connection pooling? Advantages of using a connection pool?
What does adapter class provide?
Why hibernate is better than jdbc?
Core Java 
