java.sql.CallableStatement

java.sql.CallableStatement is an interface for executing stored procedures.

Description

The JDBC API provides SQL escape syntax for stored procedures. This allows stored procedures to be called in a standard way for all relational database management systems (RDBMSs). One form of the escape syntax contains a result parameter, while the other does not. The result parameter must be registered as an OUT parameter when it is used. Other parameters can be used for input, output, or both. The parameters are referenced in sequence by number. The number of the first parameter is 1.

{?= call <procedure-name>[(<arg1>,<arg2>, ...)]}  
{call <procedure-name>[(<arg1>,<arg2>, ...)]}

The values of IN parameters are set by using set methods inherited from PreparedStatement. The type of all OUT parameters must be registered before the stored procedure is executed. The parameter values are retrieved by using get methods provided by this class.

A CallableStatement object can return one or more ResultSet objects. You can use methods inherited from Statement to process multiple ResultSet objects.

For maximum portability, a call's ResultSet objects and update counts need to be processed before the output parameter values are obtained.

Methods