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 result parameters, while another does not. The result parameters must be registered as OUT parameters when they are 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 value of an IN parameter is set by using the set method inherited from PreparedStatement. All types of OUT parameters must be registered before the stored procedure is executed. The parameter values are retrieved by using the get method provided by the corresponding class.

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

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

Methods