Pages Navigation Menu

Coding is much easier than you think

JDBC CallableStatement

JDBC CallableStatement

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.
Handling parameters
In general a CallableStatement objects may take three types of parameters:
In the upcoming tutorial we will learn about calling a Oracle stored procedure via JDBC CallableStatement.

About Mohaideen Jamil

I'm a Full stack developer of IT exp in J2EE, AngularJs, MicroServices, Docker, Spring (Boot, MVC, Cloud), Bluemix, DevOps. Follow me on Facebook or Google Plus. If you like my tutorials, consider making a donation to this charity, thanks.

%d bloggers like this: