prepareCall(String sql)

Syntax:

CallableStatement prepareCall(String sql) throws SQLException

Description:

Creates a CallableStatement object for calling database stored procedures. The CallableStatement object provides methods for setting up its IN and OUT parameters, and methods for executing the call to a stored procedure.

Result sets created using the returned CallableStatement object will by default be type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY. The holdability of the created result sets can be determined by calling getHoldability().

Parameters:

sql

Type: String 

an SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is specified using JDBC call escape syntax.

Returns:

Type: CallableStatement 

a new default CallableStatement object containing the pre-compiled SQL statement

Throws:

SQLException - if a database access error occurs

Reference:

For more information, reference JDBC documentation for: Connection.prepareCall(String)