{?= 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.
For maximum portability, a call's ResultSet objects and
update counts should be processed prior to getting the values of output
parameters.
Connection#prepareCall, ResultSet
| Modifier and Type | Method and Description |
|---|---|
| public Array | Returns: the parameter value as anArray object in
the Java programming language. If the value was SQL NULL, the
value null is returned.the first parameter is 1, the second is 2, and
so on parameterIndex)Retrieves the value of the designated JDBC |
| public Array | Returns: the parameter value as anArray object in
Java programming language. If the value was SQL NULL,
the value null is returned.the name of the parameter parameterName)Retrieves the value of a JDBC |
| public BigDecimal | Returns: the parameter value. If the value is SQLNULL, the result
is null.the first parameter is 1, the second is 2,
and so on parameterIndex, int the number of digits to the right of the decimal point scale)
Deprecated
since 1.2. use
getBigDecimal(int parameterIndex)
or getBigDecimal(String parameterName)
Retrieves the value of the designated JDBC |
| public BigDecimal | Returns: the parameter value in full precision. If the value is SQLNULL, the result is null.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public BigDecimal | Returns: the parameter value in full precision. If the value is SQLNULL, the result is null.the name of the parameter parameterName)Retrieves the value of a JDBC |
| public Blob | Returns: the parameter value as aBlob object in the
Java programming language. If the value was SQL NULL, the value
null is returned.the first parameter is 1, the second is 2, and so on parameterIndex)Retrieves the value of the designated JDBC |
| public Blob | Returns: the parameter value as aBlob object in the
Java programming language. If the value was SQL NULL,
the value null is returned.the name of the parameter parameterName)Retrieves the value of a JDBC |
| public boolean | Returns: the parameter value. If the value is SQLNULL,
the result is false.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public boolean | Returns: the parameter value. If the value is SQLNULL, the result
is false.the name of the parameter parameterName)Retrieves the value of a JDBC |
| public byte | Returns: the parameter value. If the value is SQLNULL, the result
is 0.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public byte | |
| public byte[] | Returns: the parameter value. If the value is SQLNULL, the result
is null.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public byte[] | |
| public Reader | Returns: ajava.io.Reader object that contains the parameter
value; if the value is SQL NULL, the value returned is
null in the Java programming language.the first parameter is 1, the second is 2, ... parameterIndex)Retrieves the value of the designated parameter as a
|
| public Reader | Returns: ajava.io.Reader object that contains the parameter
value; if the value is SQL NULL, the value returned is
null in the Java programming languagethe name of the parameter parameterName)Retrieves the value of the designated parameter as a
|
| public Clob | Returns: the parameter value as aClob object in the
Java programming language. If the value was SQL NULL, the
value null is returned.the first parameter is 1, the second is 2, and
so on parameterIndex)Retrieves the value of the designated JDBC |
| public Clob | |
| public Date | Returns: the parameter value. If the value is SQLNULL, the result
is null.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public Date | Returns: the parameter value. If the value is SQLNULL, the result
is null.the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the dateRetrieves the value of the designated JDBC |
| public Date | |
| public Date | Returns: the parameter value. If the value is SQLNULL,
the result is null.the name of the parameter parameterName, Calendar the cal)Calendar object the driver will use
to construct the dateRetrieves the value of a JDBC |
| public double | Returns: the parameter value. If the value is SQLNULL, the result
is 0.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public double | |
| public float | Returns: the parameter value. If the value is SQLNULL, the result
is 0.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public float | |
| public int | Returns: the parameter value. If the value is SQLNULL, the result
is 0.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public int | |
| public long | Returns: the parameter value. If the value is SQLNULL, the result
is 0.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public long | |
| public Reader | Returns: ajava.io.Reader object that contains the parameter
value; if the value is SQL NULL, the value returned is
null in the Java programming language.the first parameter is 1, the second is 2, ... parameterIndex)Retrieves the value of the designated parameter as a
|
| public Reader | Returns: ajava.io.Reader object that contains the parameter
value; if the value is SQL NULL, the value returned is
null in the Java programming languagethe name of the parameter parameterName)Retrieves the value of the designated parameter as a
|
| public NClob | Returns: the parameter value as aNClob object in the
Java programming language. If the value was SQL NULL, the
value null is returned.the first parameter is 1, the second is 2, and
so on parameterIndex)Retrieves the value of the designated JDBC |
| public NClob | |
| public String | Returns: aString object that maps an
NCHAR, NVARCHAR or LONGNVARCHAR valueindex of the first parameter is 1, the second is 2, ... parameterIndex)Retrieves the value of the designated |
| public String | Returns: aString object that maps an
NCHAR, NVARCHAR or LONGNVARCHAR valuethe name of the parameter parameterName)Retrieves the value of the designated |
| public Object | Returns: Ajava.lang.Object holding the OUT parameter valuethe first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated parameter as an |
| public Object | Returns: ajava.lang.Object holding the OUT parameter valuethe first parameter is 1, the second is 2, and so on parameterIndex, Map<String, Class<?>> the mapping from SQL type names to Java classes map)Returns an object representing the value of OUT parameter
|
| public Object | |
| public Object | Returns: ajava.lang.Object holding the OUT parameter valuethe name of the parameter parameterName, Map<String, Class<?>> the mapping from SQL type names to Java classes map)Returns an object representing the value of OUT parameter
|
| public < the type of the class modeled by this Class object T> T | Returns: an instance oftype holding the OUT parameter valuethe first parameter is 1, the second is 2, and so on parameterIndex, Class<T> Class representing the Java data type to convert the
designated parameter to. type)Returns an object representing the value of OUT parameter
|
| public < the type of the class modeled by this Class object T> T | Returns: an instance oftype holding the OUT parameter
valuethe name of the parameter parameterName, Class<T> Class representing the Java data type to convert
the designated parameter to. type)Returns an object representing the value of OUT parameter
|
| public Ref | Returns: the parameter value as aRef object in the
Java programming language. If the value was SQL NULL, the value
null is returned.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public Ref | Returns: the parameter value as aRef object in the
Java programming language. If the value was SQL NULL,
the value null is returned.the name of the parameter parameterName)Retrieves the value of a JDBC |
| public RowId | Returns: aRowId object that represents the JDBC ROWID
value is used as the designated parameter. If the parameter contains
a SQL NULL, then a null value is returned.the first parameter is 1, the second is 2,... parameterIndex)Retrieves the value of the designated JDBC |
| public RowId | Returns: aRowId object that represents the JDBC ROWID
value is used as the designated parameter. If the parameter contains
a SQL NULL, then a null value is returned.the name of the parameter parameterName)Retrieves the value of the designated JDBC |
| public short | Returns: the parameter value. If the value is SQLNULL, the result
is 0.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public short | |
| public SQLXML | Returns: aSQLXML object that maps an SQL XML valueindex of the first parameter is 1, the second is 2, ... parameterIndex)Retrieves the value of the designated |
| public SQLXML | |
| public String | Returns: the parameter value. If the value is SQLNULL,
the result
is null.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public String | |
| public Time | Returns: the parameter value. If the value is SQLNULL, the result
is null.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public Time | Returns: the parameter value; if the value is SQLNULL, the result
is null.the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the timeRetrieves the value of the designated JDBC |
| public Time | |
| public Time | Returns: the parameter value; if the value is SQLNULL, the result is
null.the name of the parameter parameterName, Calendar the cal)Calendar object the driver will use
to construct the timeRetrieves the value of a JDBC |
| public Timestamp | Returns: the parameter value. If the value is SQLNULL, the result
is null.the first parameter is 1, the second is 2,
and so on parameterIndex)Retrieves the value of the designated JDBC |
| public Timestamp | Returns: the parameter value. If the value is SQLNULL, the result
is null.the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the timestampRetrieves the value of the designated JDBC |
| public Timestamp | Returns: the parameter value. If the value is SQLNULL, the result
is null.the name of the parameter parameterName)Retrieves the value of a JDBC |
| public Timestamp | Returns: the parameter value. If the value is SQLNULL, the result is
null.the name of the parameter parameterName, Calendar the cal)Calendar object the driver will use
to construct the timestampRetrieves the value of a JDBC |
| public URL | Returns: ajava.net.URL object that represents the
JDBC DATALINK value used as the designated
parameterthe first parameter is 1, the second is 2,... parameterIndex)Retrieves the value of the designated JDBC |
| public URL | |
| public void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the JDBC type code defined by sqlType)java.sql.Types.
If the parameter is of JDBC type NUMERIC
or DECIMAL, the version of
registerOutParameter that accepts a scale value
should be used.Registers the OUT parameter in ordinal position
|
| public void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the SQL type code defined by sqlType, int java.sql.Types.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. scale)Registers the parameter in ordinal position
|
| public void | registerOutParameter(int
the first parameter is 1, the second is 2,... parameterIndex, int a value from sqlType, String java.the fully-qualified name of an SQL structured type typeName)Registers the designated output parameter. |
| public void | registerOutParameter(String
the name of the parameter parameterName, int the JDBC type code defined by sqlType)java.sql.Types.
If the parameter is of JDBC type NUMERIC
or DECIMAL, the version of
registerOutParameter that accepts a scale value
should be used.Registers the OUT parameter named
|
| public void | registerOutParameter(String
the name of the parameter parameterName, int SQL type code defined by sqlType, int java.sql.Types.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. scale)Registers the parameter named
|
| public void | registerOutParameter(String
the name of the parameter parameterName, int a value from sqlType, String java.the fully-qualified name of an SQL structured type typeName)Registers the designated output parameter. |
| public default void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, SQLType the JDBC type code defined by sqlType)SQLType to use to
register the OUT Parameter.
If the parameter is of JDBC type JDBCType.NUMERIC
or JDBCType.DECIMAL, the version of
registerOutParameter that accepts a scale value
should be used.Registers the OUT parameter in ordinal position
|
| public default void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, SQLType the JDBC type code defined by sqlType, int SQLType to use to
register the OUT Parameter.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. scale)Registers the parameter in ordinal position
|
| public default void | registerOutParameter(int
the first parameter is 1, the second is 2,... parameterIndex, SQLType the JDBC type code defined by sqlType, String SQLType to use to
register the OUT Parameter.the fully-qualified name of an SQL structured type typeName)Registers the designated output parameter. |
| public default void | registerOutParameter(String
the name of the parameter parameterName, SQLType the JDBC type code defined by sqlType)SQLType to use to
register the OUT Parameter.
If the parameter is of JDBC type JDBCType.NUMERIC
or JDBCType.DECIMAL, the version of
registerOutParameter that accepts a scale value
should be used.Registers the OUT parameter named
|
| public default void | registerOutParameter(String
the name of the parameter parameterName, SQLType the JDBC type code defined by sqlType, int SQLType to use to
register the OUT Parameter.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. scale)Registers the parameter named
|
| public default void | registerOutParameter(String
the name of the parameter parameterName, SQLType the JDBC type code defined by sqlType, String SQLType to use to
register the OUT Parameter.the fully-qualified name of an SQL structured type typeName)Registers the designated output parameter. |
| public void | setAsciiStream(String
the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x, int the number of bytes in the stream length)Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public void | setAsciiStream(String
the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x, long the number of bytes in the stream length)Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public void | setAsciiStream(String
the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x)Sets the designated parameter to the given input stream. |
| public void | setBigDecimal(String
the name of the parameter parameterName, BigDecimal the parameter value x)Sets the designated parameter to the given
|
| public void | setBinaryStream(String
the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x, int the number of bytes in the stream length)Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public void | setBinaryStream(String
the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x, long the number of bytes in the stream length)Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public void | setBinaryStream(String
the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x)Sets the designated parameter to the given input stream. |
| public void | setBlob(String
the name of the parameter to be set
the second is 2, ... parameterName, InputStream An object that contains the data to set the parameter
value to. inputStream, long the number of bytes in the parameter data. length)Sets the designated parameter to an |
| public void | |
| public void | setBlob(String
the name of the parameter parameterName, InputStream An object that contains the data to set the parameter
value to. inputStream)Sets the designated parameter to an |
| public void | setBoolean(String
the name of the parameter parameterName, boolean the parameter value x)Sets the designated parameter to the given Java |
| public void | |
| public void | |
| public void | setCharacterStream(String
the name of the parameter parameterName, Reader the reader, int java.io.Reader object that
contains the UNICODE data used as the designated parameterthe number of characters in the stream length)Sets the designated parameter to the given |
| public void | setCharacterStream(String
the name of the parameter parameterName, Reader the reader, long java.io.Reader object that
contains the UNICODE data used as the designated parameterthe number of characters in the stream length)Sets the designated parameter to the given |
| public void | setCharacterStream(String
the name of the parameter parameterName, Reader the reader)java.io.Reader object that contains the
Unicode dataSets the designated parameter to the given |
| public void | |
| public void | |
| public void | |
| public void | |
| public void | |
| public void | |
| public void | |
| public void | |
| public void | |
| public void | setNCharacterStream(String
the name of the parameter to be set parameterName, Reader the parameter value value, long the number of characters in the parameter data. length)Sets the designated parameter to a |
| public void | setNCharacterStream(String
the name of the parameter parameterName, Reader the parameter value value)Sets the designated parameter to a |
| public void | |
| public void | |
| public void | |
| public void | setNString(String
the name of the parameter to be set parameterName, String the parameter value value)Sets the designated parameter to the given |
| public void | |
| public void | |
| public void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be
sent to the database. The scale argument may further qualify this type. targetSqlType, int for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types,
this is the number of digits after the decimal point. For all other
types, this value will be ignored. scale)Sets the value of the designated parameter with the given object. |
| public void | |
| public void | |
| public default void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value x, SQLType the SQL type to be
sent to the database. The scale argument may further qualify this type. targetSqlType, int for scaleOrLength)java.sql.JDBCType.DECIMAL
or java.sql.JDBCType.NUMERIC types,
this is the number of digits after the decimal point. For
Java Object types InputStream and Reader,
this is the length
of the data in the stream or reader. For all other types,
this value will be ignored.Sets the value of the designated parameter with the given object. |
| public default void | |
| public void | |
| public void | |
| public void | |
| public void | |
| public void | |
| public void | |
| public void | setTimestamp(String
the name of the parameter parameterName, Timestamp the parameter value x)Sets the designated parameter to the given |
| public void | setTimestamp(String
the name of the parameter parameterName, Timestamp the parameter value x, Calendar the cal)Calendar object the driver will use
to construct the timestampSets the designated parameter to the given |
| public void | |
| public boolean | Returns: true if the last parameter read was SQL
NULL; false otherwiseRetrieves whether the last OUT parameter read had the value of
SQL |