what r callable statement and give their proper use
Answer Posted / prajal
Callable statement (java.sql.CallableStatement) are used for
calling a Stored Procedure.
Syntax is as below-
//prepare a procedure call
String procedureCall="call testProcedure(:1,:2,:3)";
//prepare a callable statement
CallableStatement
cStmt=connectionObject.prepareCall(procedureCall);
// Set the Input Parameters to the procedure
cStmt.setInt(1, testID);
cStmt.setInt(2, testNumber);
// Register Output Parameters
cStmt.registerOutParameter(3, Types.VARCHAR);
// Execute the Callable Statement
cStmt.execute();
// Resulting Values from the Callable Statement is assigned
to the Message variable
String message = cStmt.getString(3);
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is string in java?
What is the purpose of the file class in java programming?
How do you add an arraylist to an array in java?
What is better- service oriented or batch oriented solutions?
What does this () mean in constructor chaining concept?
Can a constructor have different name than a class name in java?
What is mvc in java?
Is object a data type in java?
What is difference between fileinputstream and filereader in java?
Why java does not support pointers?
What is the difference between hashset and treeset in java?
What is double parsedouble in java?
What is a substitution variable?
Why can we not override static method?
What is a boolean output?