PostgreSQL JDBC Driver 42.7.2 · org.postgresql.jdbc.PgCallableStatement

Modifier and Type	Field and Description
protected @Nullable @Nullable Object[]	callResult
private @Nullable int[]	functionReturnType
private final boolean	isFunction
private int	lastIndex
private boolean	returnTypeSet
private @Nullable int[]	testReturn

Access	Constructor and Description
pack-priv	PgCallableStatement(PgConnection connection, String sql, int rsType, int rsConcurrency, int rsHoldability)

Method Summary

Modifier and Type	Method and Description
protected @Nullable Object	checkIndex(@Positive int parameter index (1-based) parameterIndex, int type 1 type1, int type 2 type2, String getter name getName) helperfunction for the getXXX calls to check isFunction and index == 1 Compare BOTH type fields against the return type.
protected @Nullable Object	checkIndex(@Positive int parameter index (1-based) parameterIndex, int type type, String getter name getName) Helper function for the getXXX calls to check isFunction and index == 1.
protected BatchResultHandler	createBatchHandler(Query[] queries, @Nullable ParameterList[] parameterLists)
public int	executeUpdate() Overrides org.postgresql.jdbc.PgPreparedStatement.executeUpdate. Implements java.sql.PreparedStatement.executeUpdate. Executes the SQL statement in this `PreparedStatement` object, which must be an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement.
public boolean	executeWithFlags(int additional `QueryExecutor` flags for execution; these are bitwise-ORed into the default flags. flags) Overrides org.postgresql.jdbc.PgPreparedStatement.executeWithFlags. Implements org.postgresql.core.BaseStatement.executeWithFlags. Execute a prepared query, passing additional query flags.
public @Nullable Array	getArray(int the first parameter is 1, the second is 2, and so on i) Implements java.sql.CallableStatement.getArray. Retrieves the value of the designated JDBC `ARRAY` parameter as an `java.sql.Array` object in the Java programming language.
public @Nullable Array	getArray(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getArray. Retrieves the value of a JDBC `ARRAY` parameter as an `java.sql.Array` object in the Java programming language.
public @Nullable BigDecimal	getBigDecimal(@Positive int 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) Implements java.sql.CallableStatement.getBigDecimal. Retrieves the value of the designated JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with scale digits to the right of the decimal point.
public @Nullable BigDecimal	getBigDecimal(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getBigDecimal. Retrieves the value of the designated JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with as many digits to the right of the decimal point as the value contains.
public @Nullable BigDecimal	getBigDecimal(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getBigDecimal. Retrieves the value of a JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with as many digits to the right of the decimal point as the value contains.
public @Nullable Blob	getBlob(int the first parameter is 1, the second is 2, and so on i) Implements java.sql.CallableStatement.getBlob. Retrieves the value of the designated JDBC `BLOB` parameter as a `java.sql.Blob` object in the Java programming language.
public @Nullable Blob	getBlob(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getBlob. Retrieves the value of a JDBC `BLOB` parameter as a `java.sql.Blob` object in the Java programming language.
public boolean	getBoolean(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getBoolean. Retrieves the value of the designated JDBC `BIT` or `BOOLEAN` parameter as a `boolean` in the Java programming language.
public boolean	getBoolean(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getBoolean. Retrieves the value of a JDBC `BIT` or `BOOLEAN` parameter as a `boolean` in the Java programming language.
public byte	getByte(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getByte. Retrieves the value of the designated JDBC `TINYINT` parameter as a `byte` in the Java programming language.
public byte	getByte(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getByte. Retrieves the value of a JDBC `TINYINT` parameter as a `byte` in the Java programming language.
public @Nullable byte[]	getBytes(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getBytes. Retrieves the value of the designated JDBC `BINARY` or `VARBINARY` parameter as an array of `byte` values in the Java programming language.
public @Nullable byte[]	getBytes(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getBytes. Retrieves the value of a JDBC `BINARY` or `VARBINARY` parameter as an array of `byte` values in the Java programming language.
private @Nullable Object	getCallResult(@Positive int parameterIndex)
public @Nullable Reader	getCharacterStream(@Positive int the first parameter is 1, the second is 2, ... parameterIndex) Implements java.sql.CallableStatement.getCharacterStream. Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
public @Nullable Reader	getCharacterStream(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getCharacterStream. Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
public @Nullable Clob	getClob(int the first parameter is 1, the second is 2, and so on i) Implements java.sql.CallableStatement.getClob. Retrieves the value of the designated JDBC `CLOB` parameter as a `java.sql.Clob` object in the Java programming language.
public @Nullable Clob	getClob(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getClob. Retrieves the value of a JDBC `CLOB` parameter as a `java.sql.Clob` object in the Java programming language.
public @Nullable Date	getDate(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getDate. Retrieves the value of the designated JDBC `DATE` parameter as a `java.sql.Date` object.
public @Nullable Date	getDate(int the first parameter is 1, the second is 2, and so on i, @Nullable Calendar the `Calendar` object the driver will use to construct the date cal) Implements java.sql.CallableStatement.getDate. Retrieves the value of the designated JDBC `DATE` parameter as a `java.sql.Date` object, using the given `Calendar` object to construct the date.
public @Nullable Date	getDate(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getDate. Retrieves the value of a JDBC `DATE` parameter as a `java.sql.Date` object.
public @Nullable Date	getDate(String the name of the parameter parameterName, @Nullable Calendar the `Calendar` object the driver will use to construct the date cal) Implements java.sql.CallableStatement.getDate. Retrieves the value of a JDBC `DATE` parameter as a `java.sql.Date` object, using the given `Calendar` object to construct the date.
public double	getDouble(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getDouble. Retrieves the value of the designated JDBC `DOUBLE` parameter as a `double` in the Java programming language.
public double	getDouble(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getDouble. Retrieves the value of a JDBC `DOUBLE` parameter as a `double` in the Java programming language.
public float	getFloat(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getFloat. Retrieves the value of the designated JDBC `FLOAT` parameter as a `float` in the Java programming language.
public float	getFloat(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getFloat. Retrieves the value of a JDBC `FLOAT` parameter as a `float` in the Java programming language.
public int	getInt(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getInt. Retrieves the value of the designated JDBC `INTEGER` parameter as an `int` in the Java programming language.
public int	getInt(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getInt. Retrieves the value of a JDBC `INTEGER` parameter as an `int` in the Java programming language.
public long	getLong(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getLong. Retrieves the value of the designated JDBC `BIGINT` parameter as a `long` in the Java programming language.
public long	getLong(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getLong. Retrieves the value of a JDBC `BIGINT` parameter as a `long` in the Java programming language.
public @Nullable Reader	getNCharacterStream(@Positive int the first parameter is 1, the second is 2, ... parameterIndex) Implements java.sql.CallableStatement.getNCharacterStream. Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
public @Nullable Reader	getNCharacterStream(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getNCharacterStream. Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
public @Nullable NClob	getNClob(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getNClob. Retrieves the value of the designated JDBC `NCLOB` parameter as a `java.sql.NClob` object in the Java programming language.
public @Nullable NClob	getNClob(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getNClob. Retrieves the value of a JDBC `NCLOB` parameter as a `java.sql.NClob` object in the Java programming language.
public String	getNString(@Positive int index of the first parameter is 1, the second is 2, ... parameterIndex) Implements java.sql.CallableStatement.getNString. Retrieves the value of the designated `NCHAR`, `NVARCHAR` or `LONGNVARCHAR` parameter as a `String` in the Java programming language.
public @Nullable String	getNString(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getNString. Retrieves the value of the designated `NCHAR`, `NVARCHAR` or `LONGNVARCHAR` parameter as a `String` in the Java programming language.
public @Nullable Object	getObject(@Positive int the first parameter is 1, the second is 2, and so on i, @Nullable Map<String, Class<?>> the mapping from SQL type names to Java classes map) Implements java.sql.CallableStatement.getObject. Returns an object representing the value of OUT parameter `parameterIndex` and uses `map` for the custom mapping of the parameter value.
public @Nullable Object	getObject(String the name of the parameter s, @Nullable Map<String, Class<?>> the mapping from SQL type names to Java classes map) Implements java.sql.CallableStatement.getObject. Returns an object representing the value of OUT parameter `parameterName` and uses `map` for the custom mapping of the parameter value.
public @Nullable Object	getObject(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getObject. Retrieves the value of the designated parameter as an `Object` in the Java programming language.
public <T> @Nullable T	getObject(@Positive int the 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) Implements java.sql.CallableStatement.getObject. Returns an object representing the value of OUT parameter `parameterIndex` and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
public <T> @Nullable T	getObject(String the name of the parameter parameterName, Class<T> Class representing the Java data type to convert the designated parameter to. type) Implements java.sql.CallableStatement.getObject. Returns an object representing the value of OUT parameter `parameterName` and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
public @Nullable Object	getObject(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getObject. Retrieves the value of a parameter as an `Object` in the Java programming language.
public @Nullable Object	getObjectImpl(int i, @Nullable Map<String, Class<?>> map)
public @Nullable Object	getObjectImpl(String parameterName, @Nullable Map<String, Class<?>> map)
public @Nullable Ref	getRef(int the first parameter is 1, the second is 2, and so on i) Implements java.sql.CallableStatement.getRef. Retrieves the value of the designated JDBC `REF(<structured-type>)` parameter as a `java.sql.Ref` object in the Java programming language.
public @Nullable Ref	getRef(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getRef. Retrieves the value of a JDBC `REF(<structured-type>)` parameter as a `java.sql.Ref` object in the Java programming language.
public @Nullable RowId	getRowId(@Positive int the first parameter is 1, the second is 2,... parameterIndex) Implements java.sql.CallableStatement.getRowId. Retrieves the value of the designated JDBC `ROWID` parameter as a `java.sql.RowId` object.
public @Nullable RowId	getRowId(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getRowId. Retrieves the value of the designated JDBC `ROWID` parameter as a `java.sql.RowId` object.
public short	getShort(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getShort. Retrieves the value of the designated JDBC `SMALLINT` parameter as a `short` in the Java programming language.
public short	getShort(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getShort. Retrieves the value of a JDBC `SMALLINT` parameter as a `short` in the Java programming language.
public @Nullable SQLXML	getSQLXML(@Positive int index of the first parameter is 1, the second is 2, ... parameterIndex) Implements java.sql.CallableStatement.getSQLXML. Retrieves the value of the designated `SQL XML` parameter as a `java.sql.SQLXML` object in the Java programming language.
public @Nullable SQLXML	getSQLXML(String the name of the parameter parameterIndex) Implements java.sql.CallableStatement.getSQLXML. Retrieves the value of the designated `SQL XML` parameter as a `java.sql.SQLXML` object in the Java programming language.
public @Nullable String	getString(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getString. Retrieves the value of the designated JDBC `CHAR`, `VARCHAR`, or `LONGVARCHAR` parameter as a `String` in the Java programming language.
public @Nullable String	getString(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getString. Retrieves the value of a JDBC `CHAR`, `VARCHAR`, or `LONGVARCHAR` parameter as a `String` in the Java programming language.
public @Nullable Time	getTime(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getTime. Retrieves the value of the designated JDBC `TIME` parameter as a `java.sql.Time` object.
public @Nullable Time	getTime(int the first parameter is 1, the second is 2, and so on i, @Nullable Calendar the `Calendar` object the driver will use to construct the time cal) Implements java.sql.CallableStatement.getTime. Retrieves the value of the designated JDBC `TIME` parameter as a `java.sql.Time` object, using the given `Calendar` object to construct the time.
public Time	getTime(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getTime. Retrieves the value of a JDBC `TIME` parameter as a `java.sql.Time` object.
public @Nullable Time	getTime(String the name of the parameter parameterName, @Nullable Calendar the `Calendar` object the driver will use to construct the time cal) Implements java.sql.CallableStatement.getTime. Retrieves the value of a JDBC `TIME` parameter as a `java.sql.Time` object, using the given `Calendar` object to construct the time.
public @Nullable Timestamp	getTimestamp(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getTimestamp. Retrieves the value of the designated JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object.
public @Nullable Timestamp	getTimestamp(int the first parameter is 1, the second is 2, and so on i, @Nullable Calendar the `Calendar` object the driver will use to construct the timestamp cal) Implements java.sql.CallableStatement.getTimestamp. Retrieves the value of the designated JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object, using the given `Calendar` object to construct the `Timestamp` object.
public @Nullable Timestamp	getTimestamp(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getTimestamp. Retrieves the value of a JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object.
public @Nullable Timestamp	getTimestamp(String the name of the parameter parameterName, @Nullable Calendar the `Calendar` object the driver will use to construct the timestamp cal) Implements java.sql.CallableStatement.getTimestamp. Retrieves the value of a JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object, using the given `Calendar` object to construct the `Timestamp` object.
public @Nullable URL	getURL(@Positive int the first parameter is 1, the second is 2,... parameterIndex) Implements java.sql.CallableStatement.getURL. Retrieves the value of the designated JDBC `DATALINK` parameter as a `java.net.URL` object.
public @Nullable URL	getURL(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getURL. Retrieves the value of a JDBC `DATALINK` parameter as a `java.net.URL` object.
public void	registerOutParameter(@Positive int the first parameter is 1, the second is 2,... parameterIndex, int SQL type code defined by java.sql.Types; for parameters of type Numeric or Decimal use the version of registerOutParameter that accepts a scale value sqlType) Implements java.sql.CallableStatement.registerOutParameter. Registers the OUT parameter in ordinal position `parameterIndex` to the JDBC type `sqlType`.
public void	registerOutParameter(@Positive int the first parameter is 1, the second is 2,... parameterIndex, int a value from `java.sql.Types` sqlType, String the fully-qualified name of an SQL structured type typeName) Implements java.sql.CallableStatement.registerOutParameter. Registers the designated output parameter.
public void	registerOutParameter(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex, SQLType the JDBC type code defined by `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. sqlType) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the OUT parameter in ordinal position `parameterIndex` to the JDBC type `sqlType`.
public void	registerOutParameter(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex, SQLType the JDBC type code defined by `SQLType` to use to register the OUT Parameter. sqlType, int the desired number of digits to the right of the decimal point. It must be greater than or equal to zero. scale) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the parameter in ordinal position `parameterIndex` to be of JDBC type `sqlType`.
public void	registerOutParameter(@Positive int the first parameter is 1, the second is 2,... parameterIndex, SQLType the JDBC type code defined by `SQLType` to use to register the OUT Parameter. sqlType, String the fully-qualified name of an SQL structured type typeName) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the designated output parameter.
public void	registerOutParameter(String the name of the parameter parameterName, SQLType the JDBC type code defined by `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. sqlType) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the OUT parameter named `parameterName` to the JDBC type `sqlType`.
public void	registerOutParameter(String the name of the parameter parameterName, SQLType the JDBC type code defined by `SQLType` to use to register the OUT Parameter. sqlType, int the desired number of digits to the right of the decimal point. It must be greater than or equal to zero. scale) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the parameter named `parameterName` to be of JDBC type `sqlType`.
public void	registerOutParameter(String the name of the parameter parameterName, SQLType the JDBC type code defined by `SQLType` to use to register the OUT Parameter. sqlType, String the fully-qualified name of an SQL structured type typeName) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the designated output parameter.
public void	registerOutParameter(String the name of the parameter parameterName, int the JDBC type code defined by `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. sqlType) Implements java.sql.CallableStatement.registerOutParameter. Registers the OUT parameter named `parameterName` to the JDBC type `sqlType`.
public void	registerOutParameter(String the name of the parameter parameterName, int SQL type code defined by `java.sql.Types`. sqlType, int the desired number of digits to the right of the decimal point. It must be greater than or equal to zero. scale) Implements java.sql.CallableStatement.registerOutParameter. Registers the parameter named `parameterName` to be of JDBC type `sqlType`.
public void	registerOutParameter(String the name of the parameter parameterName, int a value from `java.sql.Types` sqlType, String the fully-qualified name of an SQL structured type typeName) Implements java.sql.CallableStatement.registerOutParameter. Registers the designated output parameter.
public void	registerOutParameter(@Positive int the first parameter is 1, the second is 2, and so on parameterIndex, int the SQL type code defined by `java.sql.Types`. sqlType, int the desired number of digits to the right of the decimal point. It must be greater than or equal to zero. scale) Implements java.sql.CallableStatement.registerOutParameter. Registers the parameter in ordinal position `parameterIndex` to be of JDBC type `sqlType`.
public void	setAsciiStream(String the name of the parameter parameterName, @Nullable InputStream the Java input stream that contains the ASCII parameter value value, long the number of bytes in the stream length) Implements java.sql.CallableStatement.setAsciiStream. 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, @Nullable InputStream the Java input stream that contains the ASCII parameter value value) Implements java.sql.CallableStatement.setAsciiStream. Sets the designated parameter to the given input stream.
public void	setAsciiStream(String the name of the parameter parameterName, @Nullable InputStream the Java input stream that contains the ASCII parameter value x, int the number of bytes in the stream length) Implements java.sql.CallableStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setBigDecimal(String the name of the parameter parameterName, @Nullable BigDecimal the parameter value x) Implements java.sql.CallableStatement.setBigDecimal. Sets the designated parameter to the given `java.math.BigDecimal` value.
public void	setBinaryStream(String the name of the parameter parameterName, @Nullable InputStream the java input stream which contains the binary parameter value value, long the number of bytes in the stream length) Implements java.sql.CallableStatement.setBinaryStream. 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, @Nullable InputStream the java input stream which contains the binary parameter value value) Implements java.sql.CallableStatement.setBinaryStream. Sets the designated parameter to the given input stream.
public void	setBinaryStream(String the name of the parameter parameterName, @Nullable InputStream the java input stream which contains the binary parameter value x, int the number of bytes in the stream length) Implements java.sql.CallableStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setBlob(String the name of the parameter to be set the second is 2, ... parameterName, @Nullable InputStream An object that contains the data to set the parameter value to. inputStream, long the number of bytes in the parameter data. length) Implements java.sql.CallableStatement.setBlob. Sets the designated parameter to an `InputStream` object.
public void	setBlob(String the name of the parameter parameterName, @Nullable InputStream An object that contains the data to set the parameter value to. inputStream) Implements java.sql.CallableStatement.setBlob. Sets the designated parameter to an `InputStream` object.
public void	setBlob(String the name of the parameter parameterName, @Nullable Blob a `Blob` object that maps an SQL `BLOB` value x) Implements java.sql.CallableStatement.setBlob. Sets the designated parameter to the given `java.sql.Blob` object.
public void	setBoolean(String the name of the parameter parameterName, boolean the parameter value x) Implements java.sql.CallableStatement.setBoolean. Sets the designated parameter to the given Java `boolean` value.
public void	setByte(String the name of the parameter parameterName, byte the parameter value x) Implements java.sql.CallableStatement.setByte. Sets the designated parameter to the given Java `byte` value.
public void	setBytes(String the name of the parameter parameterName, @Nullable byte[] the parameter value x) Implements java.sql.CallableStatement.setBytes. Sets the designated parameter to the given Java array of bytes.
public void	setCharacterStream(String the name of the parameter parameterName, @Nullable Reader the `java.io.Reader` object that contains the UNICODE data used as the designated parameter value, long the number of characters in the stream length) Implements java.sql.CallableStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public void	setCharacterStream(String the name of the parameter parameterName, @Nullable Reader the `java.io.Reader` object that contains the Unicode data value) Implements java.sql.CallableStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object.
public void	setCharacterStream(String the name of the parameter parameterName, @Nullable Reader the `java.io.Reader` object that contains the UNICODE data used as the designated parameter reader, int the number of characters in the stream length) Implements java.sql.CallableStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public void	setClob(String the name of the parameter to be set parameterName, @Nullable Reader An object that contains the data to set the parameter value to. reader, long the number of characters in the parameter data. length) Implements java.sql.CallableStatement.setClob. Sets the designated parameter to a `Reader` object.
public void	setClob(String the name of the parameter parameterName, @Nullable Reader An object that contains the data to set the parameter value to. reader) Implements java.sql.CallableStatement.setClob. Sets the designated parameter to a `Reader` object.
public void	setClob(String the name of the parameter parameterName, @Nullable Clob a `Clob` object that maps an SQL `CLOB` value x) Implements java.sql.CallableStatement.setClob. Sets the designated parameter to the given `java.sql.Clob` object.
public void	setDate(String the name of the parameter parameterName, @Nullable Date the parameter value x) Implements java.sql.CallableStatement.setDate. 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.
public void	setDate(String the name of the parameter parameterName, @Nullable Date the parameter value x, @Nullable Calendar the `Calendar` object the driver will use to construct the date cal) Implements java.sql.CallableStatement.setDate. Sets the designated parameter to the given `java.sql.Date` value, using the given `Calendar` object.
public void	setDouble(String the name of the parameter parameterName, double the parameter value x) Implements java.sql.CallableStatement.setDouble. Sets the designated parameter to the given Java `double` value.
public void	setFloat(String the name of the parameter parameterName, float the parameter value x) Implements java.sql.CallableStatement.setFloat. Sets the designated parameter to the given Java `float` value.
public void	setInt(String the name of the parameter parameterName, int the parameter value x) Implements java.sql.CallableStatement.setInt. Sets the designated parameter to the given Java `int` value.
public void	setLong(String the name of the parameter parameterName, long the parameter value x) Implements java.sql.CallableStatement.setLong. Sets the designated parameter to the given Java `long` value.
public void	setNCharacterStream(String the name of the parameter to be set parameterName, @Nullable Reader the parameter value value, long the number of characters in the parameter data. length) Implements java.sql.CallableStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public void	setNCharacterStream(String the name of the parameter parameterName, @Nullable Reader the parameter value value) Implements java.sql.CallableStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public void	setNClob(String the name of the parameter to be set parameterName, @Nullable NClob the parameter value value) Implements java.sql.CallableStatement.setNClob. Sets the designated parameter to a `java.sql.NClob` object.
public void	setNClob(String the name of the parameter to be set parameterName, @Nullable Reader An object that contains the data to set the parameter value to. reader, long the number of characters in the parameter data. length) Implements java.sql.CallableStatement.setNClob. Sets the designated parameter to a `Reader` object.
public void	setNClob(String the name of the parameter parameterName, @Nullable Reader An object that contains the data to set the parameter value to. reader) Implements java.sql.CallableStatement.setNClob. Sets the designated parameter to a `Reader` object.
public void	setNString(String the name of the parameter to be set parameterName, @Nullable String the parameter value value) Implements java.sql.CallableStatement.setNString. Sets the designated parameter to the given `String` object.
public void	setNull(String the name of the parameter parameterName, int the SQL type code defined in `java.sql.Types` sqlType) Implements java.sql.CallableStatement.setNull. Sets the designated parameter to SQL `NULL`.
public void	setNull(String the name of the parameter parameterName, int a value from `java.sql.Types` sqlType, String the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL `REF` value typeName) Implements java.sql.CallableStatement.setNull. Sets the designated parameter to SQL `NULL`.
public void	setObject(String the name of the parameter parameterName, @Nullable 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 `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. scaleOrLength) Overrides default java.sql.CallableStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(String the name of the parameter parameterName, @Nullable Object the object containing the input parameter value x, SQLType the SQL type to be sent to the database targetSqlType) Overrides default java.sql.CallableStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(String the name of the parameter parameterName, @Nullable 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) Implements java.sql.CallableStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(String the name of the parameter parameterName, @Nullable 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 targetSqlType) Implements java.sql.CallableStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(String the name of the parameter parameterName, @Nullable Object the object containing the input parameter value x) Implements java.sql.CallableStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setRowId(String the name of the parameter parameterName, @Nullable RowId the parameter value x) Implements java.sql.CallableStatement.setRowId. Sets the designated parameter to the given `java.sql.RowId` object.
public void	setShort(String the name of the parameter parameterName, short the parameter value x) Implements java.sql.CallableStatement.setShort. Sets the designated parameter to the given Java `short` value.
public void	setSQLXML(String the name of the parameter parameterName, @Nullable SQLXML a `SQLXML` object that maps an `SQL XML` value xmlObject) Implements java.sql.CallableStatement.setSQLXML. Sets the designated parameter to the given `java.sql.SQLXML` object.
public void	setString(String the name of the parameter parameterName, @Nullable String the parameter value x) Implements java.sql.CallableStatement.setString. Sets the designated parameter to the given Java `String` value.
public void	setTime(String the name of the parameter parameterName, @Nullable Time the parameter value x) Implements java.sql.CallableStatement.setTime. Sets the designated parameter to the given `java.sql.Time` value.
public void	setTime(String the name of the parameter parameterName, @Nullable Time the parameter value x, @Nullable Calendar the `Calendar` object the driver will use to construct the time cal) Implements java.sql.CallableStatement.setTime. Sets the designated parameter to the given `java.sql.Time` value, using the given `Calendar` object.
public void	setTimestamp(String the name of the parameter parameterName, @Nullable Timestamp the parameter value x) Implements java.sql.CallableStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value.
public void	setTimestamp(String the name of the parameter parameterName, @Nullable Timestamp the parameter value x, @Nullable Calendar the `Calendar` object the driver will use to construct the timestamp cal) Implements java.sql.CallableStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value, using the given `Calendar` object.
public void	setURL(String the name of the parameter parameterName, @Nullable URL the parameter value val) Implements java.sql.CallableStatement.setURL. Sets the designated parameter to the given `java.net.URL` object.
public boolean	wasNull() Implements java.sql.CallableStatement.wasNull. Retrieves whether the last OUT parameter read had the value of SQL `NULL`.

Inherited from org.postgresql.jdbc.PgPreparedStatement:: addBatch addBatch bindBytes bindLiteral clearParameters closeImpl createBlob createParameterMetaData execute execute executeBatch executeLargeUpdate executeQuery executeQuery executeUpdate getMetaData getParameterMetaData isOneShotQuery isUseServerPrepare maximumNumberOfParameters setArray setAsciiStream setAsciiStream setAsciiStream setBigDecimal setBinaryStream setBinaryStream setBinaryStream setBlob setBlob setBlob setBoolean setByte setBytes setCharacterStream setCharacterStream setCharacterStream setClob setClob setClob setDate setDate setDouble setFloat setInt setLong setNCharacterStream setNCharacterStream setNClob setNClob setNClob setNString setNull setNull setObject setObject setObject setObject setObject setRef setRowId setShort setSQLXML setString setString setTime setTime setTimestamp setTimestamp setUnicodeStream setURL toString transformQueriesAndParameters

pack-priv Class PgCallableStatement

Field Summary

Constructor Summary

Method Summary