CallableStatement In JDBC

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.