Interested to Buy Any Domain ? << Click Here >> for more details...
What are stored procedures? How to call them?
- 3 Answers
- 6388 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 |
Where jdbc drivermanager class is used?
What is jdbc stand for?
How can you know about drivers and database information ?
how can connection with oracle10g with java
What are the differences between stored procedure and functions?
why are using type4 driver in realtime projects?
How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?
Why are we using blob datatypes in jdbc?
How can we disable a constraint ?
Expalin the method of calling a stored procedure from jdbc.
How vendor Naming registry supports JNDI?
What type of drivers are used for web application?
Core Java 
