Answer Posted / hazarath k
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 |
Post New Answer View All Answers
Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?
Why is odbc needed?
What does the jdbc resultset interface?
How to get the Database server details in java program?
How can you make the connection using jdbc?
What are the jdbc api components?
Compare jdbc and odbc and how is jdbc required in this context.
Where jdbc drivermanager class is used?
Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?
How do I find ojdbc jar version?
What do you mean by metadata and why we are using it?
What are the considerations for deciding on transaction boundaries?
How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?
How does jdbc driver work?
Explain about the drive manager class working?
