What are stored procedures? How to call them?
- 3 Answers
- 4999 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 |
What are the 4 types of jdbc drivers?
What is jdbc and explain jdbc architecture?
Where can I find ojdbc14 jar file?
What does the jdbc resultsetmetadata interface?
what is callable statement?
How many types of JDBC drivers are there and what are they?
What are the advantages of database connection pooling?
What is the most common example type 1 driver?
Explain what should be done when a SQL exception is raised?
What is jdbc drivers in java?
What are database warnings in jdbc and how can we handle database warnings in jdbc?
What are the types of jdbc drivers that exist?
Core Java 
