Interested to Buy Any Domain ? << Click Here >> for more details...
What are stored procedures? How to call them?
- 3 Answers
- 6305 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 |
Is there any limitation for no of statments executed with in batchupdate?
What are cursor attributes?
How we say that PreparedStatment is Precompiled? where it will be compiled?
How will you perform truncation using JDBC?
What happens if we don't close the connection in jdbc?
What are different types of JDBC Drivers?
Explain about multiple implementations and drive manager?
what is JDBC?
What is in term of jdbc a datasource?
How to set the attribute concurrency in resultset?
Is jdbc secure?
What is the use of setFetchSize() and setMaxRows() methods in Statement?
Core Java 
