JDBC CallableStatement provides a way to call the stored procedure of the database. These procedures stored in the database, which may increase the performance of some database operations, since it gets executed inside the database server.
The Stored procedures possess the following features:
1) They can have input and output parameters.
2) They can have a return value.
3) They have the ability to return multiple ResultSets.
In JDBC, a stored procedure call is a single call to the database, but it may process several database requests. The stored procedure may also perform several other programmatic tasks not typically done with SQL statements.
In general a CallableStatement objects may take three types of parameters:
IN, OUT, INOUT
In the upcoming tutorial we will learn about calling a Oracle stored procedure via JDBC