The CallableStatement class provides the following functions:

• Execution of Java stored routines
• Specification of IN and INOUT parameters (a setXXX method of the PreparedStatement class is used)
• Registration of OUT and INOUT parameters
• Acquisition of OUT and INOUT parameters
• Acquisition of a result set

Because the CallableStatement class is a subclass of the PreparedStatement class, it inherits all of the PreparedStatement class functions and the Statement class functions. Note that the result set obtained with the DatabaseMetaData class within a Java stored routine can be used only within the Java stored routine. The CallableStatement class's getResultSet cannot acquire it as a dynamic result set.

For details about and usage of each method provided with the CallableStatement class, see the applicable JDBC manual.

1. All of the notes about the PreparedStatement and Statement classes applicable to the CallableStatement class, because the CallableStatement class is a subclass of the PreparedStatement class.
2. Parameter information is erased when the clearParameters method is executed. If the clearParameters method is executed after execution of the execute method but before execution of the getXXX method, the KFPJ20506-E message is output when the getXXX method is executed.
3. If you use the INOUT parameter of a Java stored routine, the java.sql.Types specified using the registerOutParameter method and the data type set using the setXXX method must be the same.