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 |
State the three different ways in which you can create a table?
What is the difference between ExecuteUpdate and ExecuteQuery?
i am user who logined the application..after that another valid user will also logind..so that is it neccessary to create jdbc connection for each and every user...plz explain it with proper answer...plz help me
How to retrieve warnings in jdbc?
what is the best way, in terms of performance, to do multiple insert/update statements, a PreparedStatement or Batch Updates?
Is jdbc a framework?
Where is jdbc used?
What are different parts of a url?
Explain different types of locks in jdbc?
How to insert and delete a row programmatically? (new feature in JDBC 2.0)
How many packages are available in jdbc api?
What are dml and ddl?