Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is addbatch jdbc?
What is jndi lookup?
Why should we close database connections in java?
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 can we store the file in the oracle database?
What do you understand by DDL and DML statements?
Write an sql to find all records having all numeric characters in a field ?
What are the different types of lockings in jdbc?
what is the meaning of following code snippets Class c=class.forName(driverClassName); Driver d=(driver)c.newInstance();
What is the return type of execute, executequery and executeupdate?
What are types of resultset?
Which type of driver is unique in jdbc?
What is the use of setFetchSize() and setMaxRows() methods in Statement?
What is db client?
How can you create jdbc statements?
