JDBC - CallableStatement IN, OUT, INOUT parameters
The CallableStatement interface allows the use of SQL statements to call stored procedures. Stored procedures are programs that have a database interface.These programs possess the following:
1) They can have input and output parameters, or parameters that are both input and output.
2) They can have a return value.
3) They have the ability to return multiple ResultSets.
Conceptually in JDBC, a stored procedure call is a single call to the database, but the program associated with the stored procedure may process hundreds of database requests. The stored procedure program may also perform a number of other programmatic tasks not typically done with SQL statements.
+notes+Part-II_JavabynataraJ+copy.png)
