CallableStatement (Java Platform SE 8 ) (original) (raw)

Modifier and Type

Method

Description

[Array](../../java/sql/Array.html "interface in java.sql")

[getArray](../../java/sql/CallableStatement.html#getArray-int-)(int parameterIndex)

Retrieves the value of the designated JDBC ARRAY parameter as anArray object in the Java programming language.

[Array](../../java/sql/Array.html "interface in java.sql")

[getArray](../../java/sql/CallableStatement.html#getArray-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC ARRAY parameter as anArray object in the Java programming language.

[BigDecimal](../../java/math/BigDecimal.html "class in java.math")

[getBigDecimal](../../java/sql/CallableStatement.html#getBigDecimal-int-)(int parameterIndex)

Retrieves the value of the designated JDBC NUMERIC parameter as ajava.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

[BigDecimal](../../java/math/BigDecimal.html "class in java.math")

[getBigDecimal](../../java/sql/CallableStatement.html#getBigDecimal-int-int-)(int parameterIndex, int scale)

[BigDecimal](../../java/math/BigDecimal.html "class in java.math")

[getBigDecimal](../../java/sql/CallableStatement.html#getBigDecimal-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC NUMERIC parameter as ajava.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

[Blob](../../java/sql/Blob.html "interface in java.sql")

[getBlob](../../java/sql/CallableStatement.html#getBlob-int-)(int parameterIndex)

Retrieves the value of the designated JDBC BLOB parameter as aBlob object in the Java programming language.

[Blob](../../java/sql/Blob.html "interface in java.sql")

[getBlob](../../java/sql/CallableStatement.html#getBlob-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC BLOB parameter as aBlob object in the Java programming language.

boolean

[getBoolean](../../java/sql/CallableStatement.html#getBoolean-int-)(int parameterIndex)

Retrieves the value of the designated JDBC BIT or BOOLEAN parameter as aboolean in the Java programming language.

boolean

[getBoolean](../../java/sql/CallableStatement.html#getBoolean-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC BIT or BOOLEAN parameter as aboolean in the Java programming language.

byte

[getByte](../../java/sql/CallableStatement.html#getByte-int-)(int parameterIndex)

Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.

byte

[getByte](../../java/sql/CallableStatement.html#getByte-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.

byte[]

[getBytes](../../java/sql/CallableStatement.html#getBytes-int-)(int parameterIndex)

Retrieves the value of the designated JDBC BINARY orVARBINARY parameter as an array of byte values in the Java programming language.

byte[]

[getBytes](../../java/sql/CallableStatement.html#getBytes-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.

[Reader](../../java/io/Reader.html "class in java.io")

[getCharacterStream](../../java/sql/CallableStatement.html#getCharacterStream-int-)(int parameterIndex)

Retrieves the value of the designated parameter as ajava.io.Reader object in the Java programming language.

[Reader](../../java/io/Reader.html "class in java.io")

[getCharacterStream](../../java/sql/CallableStatement.html#getCharacterStream-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of the designated parameter as ajava.io.Reader object in the Java programming language.

[Clob](../../java/sql/Clob.html "interface in java.sql")

[getClob](../../java/sql/CallableStatement.html#getClob-int-)(int parameterIndex)

Retrieves the value of the designated JDBC CLOB parameter as ajava.sql.Clob object in the Java programming language.

[Clob](../../java/sql/Clob.html "interface in java.sql")

[getClob](../../java/sql/CallableStatement.html#getClob-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC CLOB parameter as ajava.sql.Clob object in the Java programming language.

[Date](../../java/sql/Date.html "class in java.sql")

[getDate](../../java/sql/CallableStatement.html#getDate-int-)(int parameterIndex)

Retrieves the value of the designated JDBC DATE parameter as ajava.sql.Date object.

[Date](../../java/sql/Date.html "class in java.sql")

[getDate](../../java/sql/CallableStatement.html#getDate-int-java.util.Calendar-)(int parameterIndex,[Calendar](../../java/util/Calendar.html "class in java.util") cal)

Retrieves the value of the designated JDBC DATE parameter as ajava.sql.Date object, using the given Calendar object to construct the date.

[Date](../../java/sql/Date.html "class in java.sql")

[getDate](../../java/sql/CallableStatement.html#getDate-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC DATE parameter as ajava.sql.Date object.

[Date](../../java/sql/Date.html "class in java.sql")

[getDate](../../java/sql/CallableStatement.html#getDate-java.lang.String-java.util.Calendar-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Calendar](../../java/util/Calendar.html "class in java.util") cal)

Retrieves the value of a JDBC DATE parameter as ajava.sql.Date object, using the given Calendar object to construct the date.

double

[getDouble](../../java/sql/CallableStatement.html#getDouble-int-)(int parameterIndex)

Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.

double

[getDouble](../../java/sql/CallableStatement.html#getDouble-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.

float

[getFloat](../../java/sql/CallableStatement.html#getFloat-int-)(int parameterIndex)

Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.

float

[getFloat](../../java/sql/CallableStatement.html#getFloat-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.

int

[getInt](../../java/sql/CallableStatement.html#getInt-int-)(int parameterIndex)

Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.

int

[getInt](../../java/sql/CallableStatement.html#getInt-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.

long

[getLong](../../java/sql/CallableStatement.html#getLong-int-)(int parameterIndex)

Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.

long

[getLong](../../java/sql/CallableStatement.html#getLong-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.

[Reader](../../java/io/Reader.html "class in java.io")

[getNCharacterStream](../../java/sql/CallableStatement.html#getNCharacterStream-int-)(int parameterIndex)

Retrieves the value of the designated parameter as ajava.io.Reader object in the Java programming language.

[Reader](../../java/io/Reader.html "class in java.io")

[getNCharacterStream](../../java/sql/CallableStatement.html#getNCharacterStream-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of the designated parameter as ajava.io.Reader object in the Java programming language.

[NClob](../../java/sql/NClob.html "interface in java.sql")

[getNClob](../../java/sql/CallableStatement.html#getNClob-int-)(int parameterIndex)

Retrieves the value of the designated JDBC NCLOB parameter as ajava.sql.NClob object in the Java programming language.

[NClob](../../java/sql/NClob.html "interface in java.sql")

[getNClob](../../java/sql/CallableStatement.html#getNClob-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC NCLOB parameter as ajava.sql.NClob object in the Java programming language.

[String](../../java/lang/String.html "class in java.lang")

[getNString](../../java/sql/CallableStatement.html#getNString-int-)(int parameterIndex)

Retrieves the value of the designated NCHAR,NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.

[String](../../java/lang/String.html "class in java.lang")

[getNString](../../java/sql/CallableStatement.html#getNString-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of the designated NCHAR,NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.

[Object](../../java/lang/Object.html "class in java.lang")

[getObject](../../java/sql/CallableStatement.html#getObject-int-)(int parameterIndex)

Retrieves the value of the designated parameter as an Object in the Java programming language.

<T> T

[getObject](../../java/sql/CallableStatement.html#getObject-int-java.lang.Class-)(int parameterIndex,[Class](../../java/lang/Class.html "class in java.lang")<T> type)

Returns an object representing the value of OUT parameterparameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.

[Object](../../java/lang/Object.html "class in java.lang")

[getObject](../../java/sql/CallableStatement.html#getObject-int-java.util.Map-)(int parameterIndex,[Map](../../java/util/Map.html "interface in java.util")<[String](../../java/lang/String.html "class in java.lang"),[Class](../../java/lang/Class.html "class in java.lang")<?>> map)

Returns an object representing the value of OUT parameterparameterIndex and uses map for the custom mapping of the parameter value.

[Object](../../java/lang/Object.html "class in java.lang")

[getObject](../../java/sql/CallableStatement.html#getObject-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a parameter as an Object in the Java programming language.

<T> T

[getObject](../../java/sql/CallableStatement.html#getObject-java.lang.String-java.lang.Class-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Class](../../java/lang/Class.html "class in java.lang")<T> type)

Returns an object representing the value of OUT parameterparameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.

[Object](../../java/lang/Object.html "class in java.lang")

[getObject](../../java/sql/CallableStatement.html#getObject-java.lang.String-java.util.Map-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Map](../../java/util/Map.html "interface in java.util")<[String](../../java/lang/String.html "class in java.lang"),[Class](../../java/lang/Class.html "class in java.lang")<?>> map)

Returns an object representing the value of OUT parameterparameterName and uses map for the custom mapping of the parameter value.

[Ref](../../java/sql/Ref.html "interface in java.sql")

[getRef](../../java/sql/CallableStatement.html#getRef-int-)(int parameterIndex)

Retrieves the value of the designated JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.

[Ref](../../java/sql/Ref.html "interface in java.sql")

[getRef](../../java/sql/CallableStatement.html#getRef-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.

[RowId](../../java/sql/RowId.html "interface in java.sql")

[getRowId](../../java/sql/CallableStatement.html#getRowId-int-)(int parameterIndex)

Retrieves the value of the designated JDBC ROWID parameter as ajava.sql.RowId object.

[RowId](../../java/sql/RowId.html "interface in java.sql")

[getRowId](../../java/sql/CallableStatement.html#getRowId-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of the designated JDBC ROWID parameter as ajava.sql.RowId object.

short

[getShort](../../java/sql/CallableStatement.html#getShort-int-)(int parameterIndex)

Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.

short

[getShort](../../java/sql/CallableStatement.html#getShort-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.

[SQLXML](../../java/sql/SQLXML.html "interface in java.sql")

[getSQLXML](../../java/sql/CallableStatement.html#getSQLXML-int-)(int parameterIndex)

Retrieves the value of the designated SQL XML parameter as ajava.sql.SQLXML object in the Java programming language.

[SQLXML](../../java/sql/SQLXML.html "interface in java.sql")

[getSQLXML](../../java/sql/CallableStatement.html#getSQLXML-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of the designated SQL XML parameter as ajava.sql.SQLXML object in the Java programming language.

[String](../../java/lang/String.html "class in java.lang")

[getString](../../java/sql/CallableStatement.html#getString-int-)(int parameterIndex)

Retrieves the value of the designated JDBC CHAR,VARCHAR, or LONGVARCHAR parameter as aString in the Java programming language.

[String](../../java/lang/String.html "class in java.lang")

[getString](../../java/sql/CallableStatement.html#getString-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

[Time](../../java/sql/Time.html "class in java.sql")

[getTime](../../java/sql/CallableStatement.html#getTime-int-)(int parameterIndex)

Retrieves the value of the designated JDBC TIME parameter as ajava.sql.Time object.

[Time](../../java/sql/Time.html "class in java.sql")

[getTime](../../java/sql/CallableStatement.html#getTime-int-java.util.Calendar-)(int parameterIndex,[Calendar](../../java/util/Calendar.html "class in java.util") cal)

Retrieves the value of the designated JDBC TIME parameter as ajava.sql.Time object, using the given Calendar object to construct the time.

[Time](../../java/sql/Time.html "class in java.sql")

[getTime](../../java/sql/CallableStatement.html#getTime-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object.

[Time](../../java/sql/Time.html "class in java.sql")

[getTime](../../java/sql/CallableStatement.html#getTime-java.lang.String-java.util.Calendar-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Calendar](../../java/util/Calendar.html "class in java.util") cal)

Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object, using the given Calendar object to construct the time.

[Timestamp](../../java/sql/Timestamp.html "class in java.sql")

[getTimestamp](../../java/sql/CallableStatement.html#getTimestamp-int-)(int parameterIndex)

Retrieves the value of the designated JDBC TIMESTAMP parameter as ajava.sql.Timestamp object.

[Timestamp](../../java/sql/Timestamp.html "class in java.sql")

[getTimestamp](../../java/sql/CallableStatement.html#getTimestamp-int-java.util.Calendar-)(int parameterIndex,[Calendar](../../java/util/Calendar.html "class in java.util") cal)

Retrieves the value of the designated JDBC TIMESTAMP parameter as ajava.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.

[Timestamp](../../java/sql/Timestamp.html "class in java.sql")

[getTimestamp](../../java/sql/CallableStatement.html#getTimestamp-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC TIMESTAMP parameter as ajava.sql.Timestamp object.

[Timestamp](../../java/sql/Timestamp.html "class in java.sql")

[getTimestamp](../../java/sql/CallableStatement.html#getTimestamp-java.lang.String-java.util.Calendar-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Calendar](../../java/util/Calendar.html "class in java.util") cal)

Retrieves the value of a JDBC TIMESTAMP parameter as ajava.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.

[URL](../../java/net/URL.html "class in java.net")

[getURL](../../java/sql/CallableStatement.html#getURL-int-)(int parameterIndex)

Retrieves the value of the designated JDBC DATALINK parameter as ajava.net.URL object.

[URL](../../java/net/URL.html "class in java.net")

[getURL](../../java/sql/CallableStatement.html#getURL-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName)

Retrieves the value of a JDBC DATALINK parameter as ajava.net.URL object.

void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-int-int-)(int parameterIndex, int sqlType)

Registers the OUT parameter in ordinal positionparameterIndex to the JDBC typesqlType.

void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-int-int-int-)(int parameterIndex, int sqlType, int scale)

Registers the parameter in ordinal positionparameterIndex to be of JDBC typesqlType.

void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-int-int-java.lang.String-)(int parameterIndex, int sqlType,[String](../../java/lang/String.html "class in java.lang") typeName)

Registers the designated output parameter.

default void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-int-java.sql.SQLType-)(int parameterIndex,[SQLType](../../java/sql/SQLType.html "interface in java.sql") sqlType)

Registers the OUT parameter in ordinal positionparameterIndex to the JDBC typesqlType.

default void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-int-java.sql.SQLType-int-)(int parameterIndex,[SQLType](../../java/sql/SQLType.html "interface in java.sql") sqlType, int scale)

Registers the parameter in ordinal positionparameterIndex to be of JDBC typesqlType.

default void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-int-java.sql.SQLType-java.lang.String-)(int parameterIndex,[SQLType](../../java/sql/SQLType.html "interface in java.sql") sqlType,[String](../../java/lang/String.html "class in java.lang") typeName)

Registers the designated output parameter.

void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-java.lang.String-int-)([String](../../java/lang/String.html "class in java.lang") parameterName, int sqlType)

Registers the OUT parameter namedparameterName to the JDBC typesqlType.

void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-java.lang.String-int-int-)([String](../../java/lang/String.html "class in java.lang") parameterName, int sqlType, int scale)

Registers the parameter namedparameterName to be of JDBC typesqlType.

void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-java.lang.String-int-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName, int sqlType,[String](../../java/lang/String.html "class in java.lang") typeName)

Registers the designated output parameter.

default void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-java.lang.String-java.sql.SQLType-)([String](../../java/lang/String.html "class in java.lang") parameterName,[SQLType](../../java/sql/SQLType.html "interface in java.sql") sqlType)

Registers the OUT parameter namedparameterName to the JDBC typesqlType.

default void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-java.lang.String-java.sql.SQLType-int-)([String](../../java/lang/String.html "class in java.lang") parameterName,[SQLType](../../java/sql/SQLType.html "interface in java.sql") sqlType, int scale)

Registers the parameter namedparameterName to be of JDBC typesqlType.

default void

[registerOutParameter](../../java/sql/CallableStatement.html#registerOutParameter-java.lang.String-java.sql.SQLType-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName,[SQLType](../../java/sql/SQLType.html "interface in java.sql") sqlType,[String](../../java/lang/String.html "class in java.lang") typeName)

Registers the designated output parameter.

void

[setAsciiStream](../../java/sql/CallableStatement.html#setAsciiStream-java.lang.String-java.io.InputStream-)([String](../../java/lang/String.html "class in java.lang") parameterName,[InputStream](../../java/io/InputStream.html "class in java.io") x)

Sets the designated parameter to the given input stream.

void

[setAsciiStream](../../java/sql/CallableStatement.html#setAsciiStream-java.lang.String-java.io.InputStream-int-)([String](../../java/lang/String.html "class in java.lang") parameterName,[InputStream](../../java/io/InputStream.html "class in java.io") x, int length)

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

void

[setAsciiStream](../../java/sql/CallableStatement.html#setAsciiStream-java.lang.String-java.io.InputStream-long-)([String](../../java/lang/String.html "class in java.lang") parameterName,[InputStream](../../java/io/InputStream.html "class in java.io") x, long length)

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

void

[setBigDecimal](../../java/sql/CallableStatement.html#setBigDecimal-java.lang.String-java.math.BigDecimal-)([String](../../java/lang/String.html "class in java.lang") parameterName,[BigDecimal](../../java/math/BigDecimal.html "class in java.math") x)

Sets the designated parameter to the givenjava.math.BigDecimal value.

void

[setBinaryStream](../../java/sql/CallableStatement.html#setBinaryStream-java.lang.String-java.io.InputStream-)([String](../../java/lang/String.html "class in java.lang") parameterName,[InputStream](../../java/io/InputStream.html "class in java.io") x)

Sets the designated parameter to the given input stream.

void

[setBinaryStream](../../java/sql/CallableStatement.html#setBinaryStream-java.lang.String-java.io.InputStream-int-)([String](../../java/lang/String.html "class in java.lang") parameterName,[InputStream](../../java/io/InputStream.html "class in java.io") x, int length)

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

void

[setBinaryStream](../../java/sql/CallableStatement.html#setBinaryStream-java.lang.String-java.io.InputStream-long-)([String](../../java/lang/String.html "class in java.lang") parameterName,[InputStream](../../java/io/InputStream.html "class in java.io") x, long length)

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

void

[setBlob](../../java/sql/CallableStatement.html#setBlob-java.lang.String-java.sql.Blob-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Blob](../../java/sql/Blob.html "interface in java.sql") x)

Sets the designated parameter to the given java.sql.Blob object.

void

[setBlob](../../java/sql/CallableStatement.html#setBlob-java.lang.String-java.io.InputStream-)([String](../../java/lang/String.html "class in java.lang") parameterName,[InputStream](../../java/io/InputStream.html "class in java.io") inputStream)

Sets the designated parameter to a InputStream object.

void

[setBlob](../../java/sql/CallableStatement.html#setBlob-java.lang.String-java.io.InputStream-long-)([String](../../java/lang/String.html "class in java.lang") parameterName,[InputStream](../../java/io/InputStream.html "class in java.io") inputStream, long length)

Sets the designated parameter to a InputStream object.

void

[setBoolean](../../java/sql/CallableStatement.html#setBoolean-java.lang.String-boolean-)([String](../../java/lang/String.html "class in java.lang") parameterName, boolean x)

Sets the designated parameter to the given Java boolean value.

void

[setByte](../../java/sql/CallableStatement.html#setByte-java.lang.String-byte-)([String](../../java/lang/String.html "class in java.lang") parameterName, byte x)

Sets the designated parameter to the given Java byte value.

void

[setBytes](../../java/sql/CallableStatement.html#setBytes-java.lang.String-byte:A-)([String](../../java/lang/String.html "class in java.lang") parameterName, byte[] x)

Sets the designated parameter to the given Java array of bytes.

void

[setCharacterStream](../../java/sql/CallableStatement.html#setCharacterStream-java.lang.String-java.io.Reader-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Reader](../../java/io/Reader.html "class in java.io") reader)

Sets the designated parameter to the given Reader object.

void

[setCharacterStream](../../java/sql/CallableStatement.html#setCharacterStream-java.lang.String-java.io.Reader-int-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Reader](../../java/io/Reader.html "class in java.io") reader, int length)

Sets the designated parameter to the given Reader object, which is the given number of characters long.

void

[setCharacterStream](../../java/sql/CallableStatement.html#setCharacterStream-java.lang.String-java.io.Reader-long-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Reader](../../java/io/Reader.html "class in java.io") reader, long length)

Sets the designated parameter to the given Reader object, which is the given number of characters long.

void

[setClob](../../java/sql/CallableStatement.html#setClob-java.lang.String-java.sql.Clob-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Clob](../../java/sql/Clob.html "interface in java.sql") x)

Sets the designated parameter to the given java.sql.Clob object.

void

[setClob](../../java/sql/CallableStatement.html#setClob-java.lang.String-java.io.Reader-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Reader](../../java/io/Reader.html "class in java.io") reader)

Sets the designated parameter to a Reader object.

void

[setClob](../../java/sql/CallableStatement.html#setClob-java.lang.String-java.io.Reader-long-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Reader](../../java/io/Reader.html "class in java.io") reader, long length)

Sets the designated parameter to a Reader object.

void

[setDate](../../java/sql/CallableStatement.html#setDate-java.lang.String-java.sql.Date-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Date](../../java/sql/Date.html "class in java.sql") x)

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.

void

[setDate](../../java/sql/CallableStatement.html#setDate-java.lang.String-java.sql.Date-java.util.Calendar-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Date](../../java/sql/Date.html "class in java.sql") x,[Calendar](../../java/util/Calendar.html "class in java.util") cal)

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.

void

[setDouble](../../java/sql/CallableStatement.html#setDouble-java.lang.String-double-)([String](../../java/lang/String.html "class in java.lang") parameterName, double x)

Sets the designated parameter to the given Java double value.

void

[setFloat](../../java/sql/CallableStatement.html#setFloat-java.lang.String-float-)([String](../../java/lang/String.html "class in java.lang") parameterName, float x)

Sets the designated parameter to the given Java float value.

void

[setInt](../../java/sql/CallableStatement.html#setInt-java.lang.String-int-)([String](../../java/lang/String.html "class in java.lang") parameterName, int x)

Sets the designated parameter to the given Java int value.

void

[setLong](../../java/sql/CallableStatement.html#setLong-java.lang.String-long-)([String](../../java/lang/String.html "class in java.lang") parameterName, long x)

Sets the designated parameter to the given Java long value.

void

[setNCharacterStream](../../java/sql/CallableStatement.html#setNCharacterStream-java.lang.String-java.io.Reader-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Reader](../../java/io/Reader.html "class in java.io") value)

Sets the designated parameter to a Reader object.

void

[setNCharacterStream](../../java/sql/CallableStatement.html#setNCharacterStream-java.lang.String-java.io.Reader-long-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Reader](../../java/io/Reader.html "class in java.io") value, long length)

Sets the designated parameter to a Reader object.

void

[setNClob](../../java/sql/CallableStatement.html#setNClob-java.lang.String-java.sql.NClob-)([String](../../java/lang/String.html "class in java.lang") parameterName,[NClob](../../java/sql/NClob.html "interface in java.sql") value)

Sets the designated parameter to a java.sql.NClob object.

void

[setNClob](../../java/sql/CallableStatement.html#setNClob-java.lang.String-java.io.Reader-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Reader](../../java/io/Reader.html "class in java.io") reader)

Sets the designated parameter to a Reader object.

void

[setNClob](../../java/sql/CallableStatement.html#setNClob-java.lang.String-java.io.Reader-long-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Reader](../../java/io/Reader.html "class in java.io") reader, long length)

Sets the designated parameter to a Reader object.

void

[setNString](../../java/sql/CallableStatement.html#setNString-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName,[String](../../java/lang/String.html "class in java.lang") value)

Sets the designated parameter to the given String object.

void

[setNull](../../java/sql/CallableStatement.html#setNull-java.lang.String-int-)([String](../../java/lang/String.html "class in java.lang") parameterName, int sqlType)

Sets the designated parameter to SQL NULL.

void

[setNull](../../java/sql/CallableStatement.html#setNull-java.lang.String-int-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName, int sqlType,[String](../../java/lang/String.html "class in java.lang") typeName)

Sets the designated parameter to SQL NULL.

void

[setObject](../../java/sql/CallableStatement.html#setObject-java.lang.String-java.lang.Object-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Object](../../java/lang/Object.html "class in java.lang") x)

Sets the value of the designated parameter with the given object.

void

[setObject](../../java/sql/CallableStatement.html#setObject-java.lang.String-java.lang.Object-int-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Object](../../java/lang/Object.html "class in java.lang") x, int targetSqlType)

Sets the value of the designated parameter with the given object.

void

[setObject](../../java/sql/CallableStatement.html#setObject-java.lang.String-java.lang.Object-int-int-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Object](../../java/lang/Object.html "class in java.lang") x, int targetSqlType, int scale)

Sets the value of the designated parameter with the given object.

default void

[setObject](../../java/sql/CallableStatement.html#setObject-java.lang.String-java.lang.Object-java.sql.SQLType-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Object](../../java/lang/Object.html "class in java.lang") x,[SQLType](../../java/sql/SQLType.html "interface in java.sql") targetSqlType)

Sets the value of the designated parameter with the given object.

default void

[setObject](../../java/sql/CallableStatement.html#setObject-java.lang.String-java.lang.Object-java.sql.SQLType-int-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Object](../../java/lang/Object.html "class in java.lang") x,[SQLType](../../java/sql/SQLType.html "interface in java.sql") targetSqlType, int scaleOrLength)

Sets the value of the designated parameter with the given object.

void

[setRowId](../../java/sql/CallableStatement.html#setRowId-java.lang.String-java.sql.RowId-)([String](../../java/lang/String.html "class in java.lang") parameterName,[RowId](../../java/sql/RowId.html "interface in java.sql") x)

Sets the designated parameter to the given java.sql.RowId object.

void

[setShort](../../java/sql/CallableStatement.html#setShort-java.lang.String-short-)([String](../../java/lang/String.html "class in java.lang") parameterName, short x)

Sets the designated parameter to the given Java short value.

void

[setSQLXML](../../java/sql/CallableStatement.html#setSQLXML-java.lang.String-java.sql.SQLXML-)([String](../../java/lang/String.html "class in java.lang") parameterName,[SQLXML](../../java/sql/SQLXML.html "interface in java.sql") xmlObject)

Sets the designated parameter to the given java.sql.SQLXML object.

void

[setString](../../java/sql/CallableStatement.html#setString-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parameterName,[String](../../java/lang/String.html "class in java.lang") x)

Sets the designated parameter to the given Java String value.

void

[setTime](../../java/sql/CallableStatement.html#setTime-java.lang.String-java.sql.Time-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Time](../../java/sql/Time.html "class in java.sql") x)

Sets the designated parameter to the given java.sql.Time value.

void

[setTime](../../java/sql/CallableStatement.html#setTime-java.lang.String-java.sql.Time-java.util.Calendar-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Time](../../java/sql/Time.html "class in java.sql") x,[Calendar](../../java/util/Calendar.html "class in java.util") cal)

Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.

void

[setTimestamp](../../java/sql/CallableStatement.html#setTimestamp-java.lang.String-java.sql.Timestamp-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Timestamp](../../java/sql/Timestamp.html "class in java.sql") x)

Sets the designated parameter to the given java.sql.Timestamp value.

void

[setTimestamp](../../java/sql/CallableStatement.html#setTimestamp-java.lang.String-java.sql.Timestamp-java.util.Calendar-)([String](../../java/lang/String.html "class in java.lang") parameterName,[Timestamp](../../java/sql/Timestamp.html "class in java.sql") x,[Calendar](../../java/util/Calendar.html "class in java.util") cal)

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.

void

[setURL](../../java/sql/CallableStatement.html#setURL-java.lang.String-java.net.URL-)([String](../../java/lang/String.html "class in java.lang") parameterName,[URL](../../java/net/URL.html "class in java.net") val)

Sets the designated parameter to the given java.net.URL object.

boolean

[wasNull](../../java/sql/CallableStatement.html#wasNull--)()

Retrieves whether the last OUT parameter read had the value of SQL NULL.