What are stored procedures? How to call them?
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 jdbc odbc driver?
How is database middleware used to access legacy databases?
How do you insert images into database using jdbc?
what are the Different types of exceptions in JDBC?
What are the different types of lockings in jdbc?
What is connection data?
Explain about DSN?
What are the benefits of PreparedStatement over Statement?
What is database deadlock ? How can we avoid them?
Which is best database for java?
What is the role of the jdbc drivermanager class?
Is the JDBC-ODBC Bridge multi-threaded?