2.12 CallableStatement

2.12 CallableStatement

-          (java.sql) Interface CallableStatement :

-          public interface CallableStatement  extends PreparedStatement

-          The interface used to execute SQL stored procedures.

-          The JDBC API provides a stored procedure SQL escape syntax that allows stored procedures to be called in a standard way for all RDBMSs.

-          This escape syntax has one form that includes a result parameter and one that does not.

-          If used, the result parameter must be registered as an OUT parameter.

-          The other parameters can be used for input, output or both.

-          Parameters are referred to sequentially, by number, with the first parameter being 1.

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

-             {call <procedure-name>[<arg1>,<arg2>, ...]}

-          IN parameter values are set using the set methods inherited from  PreparedStatement.

-          The type of all OUT parameters must be registered prior to executing the stored procedure; their values are retrieved after execution via the get methods provided here.

-          A CallableStatement can return one ResultSet object or multiple ResultSet objects.

-          Multiple ResultSet objects are handled using operations inherited from Statement.