Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rama krishna dwadasi
By using CallableStatement we can call a stored Procedure
from JDBC
CallableStatement:- is an interface available in java.sql
package and is extending PreparedStatement interface.
•It is used to execute stored procedures available in the
database.
•Following is the way to create the CallableStatement object.
a)CallableStatement cs = con.prepareCall(sql);
b)CallableStatement cs = con.prepareCall(sql,int,int);
•One CallableStatement object can be used to invoke one
stored procedure only.
•CallableStatement also provides placeholder mechanism
•Following is the way to invoke the stored procedure.
CallableStatement cs = con.prepareCall(“{call p1 (?,?)}”);
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the difference between numeric and integer?
Can an unreferenced object be referenced again?
What is a flag and how does it work?
What is thread life cycle?
What is an infinite loop?
Can we create more than one object singleton class?
What is bool mean?
What is an array length?
What about method local inner classes or local inner classes in java?
What is the difference between logical data independence and physical data independence?
What is Applet Stub Interface ?
there are N number of matchboxes numbered 1...N.each matchbox contain various number of stick.Two player can alternatevely pick some amount of stick from the higest stick containing box . The player is condidered win if there is no stick after his move.Find the final move so that the move player win. Note:In case the number of stick is equal ,pick the stick from the higest numbered box.
Can we declare a class as static?
What is unmodifiable list in java?
What is ternary operator?
