|
Oracle Fusion Middleware Java API Reference for Oracle ADF Mobile Client 11g Release 1 (11.1.1) E17503-02 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface CallableStatement
An interface used to call Stored Procedures.
The JDBC API provides an SQL escape syntax allowing Stored Procedures to be called in a standard way for all
databases. The JDBC escape syntax has two forms. One form includes a result parameter. The second form does not
include a result parameter. Where the result parameter is used, it must be declared as an OUT parameter. Other
parameters can be declared as IN, OUT or INOUT. Parameters are referenced either by name or by a numerical index,
with the first parameter being 1, the second 1 and so on. Here are examples of the two forms of the escape syntax:
{ ?= call <.procedurename>.[([parameter1,parameter2,...])]}
{call <.procedurename>.[([parameter1,parameter2,...])]}
IN parameters are set before calling the procedure, using the setter methods which are inherited from
PreparedStatement
. For OUT parameters, their Type must be registered before executing the stored
procedure, and the value is retrieved using the getter methods defined in the CallableStatement interface.
CallableStatements can return one or more ResultSets. Where multiple ResultSets are returned they are accessed using
the methods inherited from the Statement
interface.
Field Summary |
---|
Fields inherited from interface oracle.adfnmc.java.sql.Statement |
---|
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO |
Method Summary | |
---|---|
Array |
getArray(int parameterIndex)
Gets the value of a specified JDBC ARRAY parameter as a java.sql.Array. |
Array |
getArray(java.lang.String parameterName)
Gets the value of a specified JDBC ARRAY parameter as a java.sql.Array. |
Blob |
getBlob(int parameterIndex)
Gets the value of a specified JDBC BLOB parameter as a java.sql.Blob |
Blob |
getBlob(java.lang.String parameterName)
Gets the value of a specified JDBC BLOB parameter as a java.sql.Blob |
boolean |
getBoolean(int parameterIndex)
Gets the value of a specified JDBC BIT parameter as a boolean |
boolean |
getBoolean(java.lang.String parameterName)
Gets the value of a specified JDBC BIT parameter as a boolean |
byte |
getByte(int parameterIndex)
Gets the value of a specified JDBC TINYINT parameter as a byte |
byte |
getByte(java.lang.String parameterName)
Gets the value of a specified JDBC TINYINT parameter as a Java byte . |
byte[] |
getBytes(int parameterIndex)
Returns a byte array representation of the indexed JDBC BINARY or VARBINARY parameter. |
byte[] |
getBytes(java.lang.String parameterName)
Returns a byte array representation of the named JDBC BINARY or VARBINARY parameter. |
Clob |
getClob(int parameterIndex)
Gets the value of a specified JDBC CLOB parameter as a java.sql.Clob |
Clob |
getClob(java.lang.String parameterName)
Gets the value of a specified JDBC CLOB parameter as a java.sql.Clob |
Date |
getDate(int parameterIndex)
Gets the value of a specified JDBC DATE parameter as a java.sql.Date. |
Date |
getDate(int parameterIndex,
java.util.Calendar cal)
Gets the value of a specified JDBC DATE parameter as a java.sql.Date., using a specified Calendar to construct the date. |
Date |
getDate(java.lang.String parameterName)
Gets the value of a specified JDBC DATE parameter as a java.sql.Date. |
Date |
getDate(java.lang.String parameterName,
java.util.Calendar cal)
Gets the value of a specified JDBC DATE parameter as a java.sql.Date., using a specified Calendar to construct the date. |
double |
getDouble(int parameterIndex)
Gets the value of a specified JDBC DOUBLE parameter as a double |
double |
getDouble(java.lang.String parameterName)
Gets the value of a specified JDBC DOUBLE parameter as a double |
float |
getFloat(int parameterIndex)
Gets the value of a specified JDBC FLOAT parameter as a float |
float |
getFloat(java.lang.String parameterName)
Gets the value of a specified JDBC FLOAT parameter as a Java float . |
int |
getInt(int parameterIndex)
Gets the value of a specified JDBC INTEGER parameter as an int |
int |
getInt(java.lang.String parameterName)
Gets the value of a specified JDBC INTEGER parameter as an int |
long |
getLong(int parameterIndex)
Gets the value of a specified JDBC BIGINT parameter as a long |
long |
getLong(java.lang.String parameterName)
Gets the value of a specified JDBC BIGINT parameter as a long |
java.lang.Object |
getObject(int parameterIndex)
Gets the value of a specified parameter as a Java Object . |
java.lang.Object |
getObject(java.lang.String parameterName)
Gets the value of a specified parameter as an Object. |
Ref |
getRef(int parameterIndex)
Gets the value of a specified JDBC REF( |
Ref |
getRef(java.lang.String parameterName)
Gets the value of a specified JDBC REF( |
short |
getShort(int parameterIndex)
Gets the value of a specified JDBC SMALLINT parameter as a short |
short |
getShort(java.lang.String parameterName)
Gets the value of a specified JDBC SMALLINT parameter as a short |
java.lang.String |
getString(int parameterIndex)
Returns the indexed parameter's value as a string. |
java.lang.String |
getString(java.lang.String parameterName)
Returns the named parameter's value as a string. |
Time |
getTime(int parameterIndex)
Gets the value of a specified JDBC TIME parameter as a java.sql.Time. |
Time |
getTime(int parameterIndex,
java.util.Calendar cal)
Gets the value of a specified JDBC TIME parameter as a java.sql.Time, using the supplied Calendar to construct the time. |
Time |
getTime(java.lang.String parameterName)
Gets the value of a specified JDBC TIME parameter as a |
Time |
getTime(java.lang.String parameterName,
java.util.Calendar cal)
Gets the value of a specified JDBC TIME parameter as a java.sql.Time, using the supplied Calendar to construct the time. |
Timestamp |
getTimestamp(int parameterIndex)
Returns the indexed parameter's TIMESTAMP value as a java.sql.Timestamp . |
Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar cal)
Returns the indexed parameter's TIMESTAMP value as a java.sql.Timestamp . |
Timestamp |
getTimestamp(java.lang.String parameterName)
Returns the named parameter's TIMESTAMP value as a java.sql.Timestamp . |
Timestamp |
getTimestamp(java.lang.String parameterName,
java.util.Calendar cal)
Returns the indexed parameter's TIMESTAMP value as a java.sql.Timestamp . |
void |
registerOutParameter(int parameterIndex,
int sqlType)
Defines the Type of a specified OUT parameter. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Defines the Type of a specified OUT parameter. |
void |
registerOutParameter(int paramIndex,
int sqlType,
java.lang.String typeName)
Defines the Type of a specified OUT parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType)
Defines the Type of a specified OUT parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale)
Defines the Type of a specified OUT parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Defines the Type of a specified OUT parameter. |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream theInputStream,
int length)
Sets the value of a specified parameter to the content of a supplied InputStream, which has a specified number of bytes. |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream theInputStream,
int length)
Sets the value of a specified parameter to the content of a supplied binary InputStream, which has a specified number of bytes. |
void |
setBoolean(java.lang.String parameterName,
boolean theBoolean)
Sets the value of a specified parameter to a supplied boolean value. |
void |
setByte(java.lang.String parameterName,
byte theByte)
Sets the value of a specified parameter to a supplied byte value. |
void |
setBytes(java.lang.String parameterName,
byte[] theBytes)
Sets the value of a specified parameter to a supplied array of bytes. |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length)
Sets the value of a specified parameter to the character content of a Reader object, with the specified length of character data. |
void |
setDate(java.lang.String parameterName,
Date theDate)
Sets the value of a specified parameter to a supplied java.sql.Date value. |
void |
setDate(java.lang.String parameterName,
Date theDate,
java.util.Calendar cal)
Sets the value of a specified parameter to a supplied java.sql.Date value, using a supplied Calendar to map the Date. |
void |
setDouble(java.lang.String parameterName,
double theDouble)
Sets the value of a specified parameter to a supplied double value. |
void |
setFloat(java.lang.String parameterName,
float theFloat)
Sets the value of a specified parameter to to a supplied float value. |
void |
setInt(java.lang.String parameterName,
int theInt)
Sets the value of a specified parameter to a supplied int value. |
void |
setLong(java.lang.String parameterName,
long theLong)
Sets the value of a specified parameter to a supplied long value. |
void |
setNull(java.lang.String parameterName,
int sqlType)
Sets the value of a specified parameter to SQL NULL. |
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Sets the value of a specified parameter to be SQL NULL where the parameter type is either REF or user
defined (e.g. |
void |
setObject(java.lang.String parameterName,
java.lang.Object theObject)
Sets the value of a specified parameter using a supplied object. |
void |
setObject(java.lang.String parameterName,
java.lang.Object theObject,
int targetSqlType)
Sets the value of a specified parameter using a supplied object. |
void |
setObject(java.lang.String parameterName,
java.lang.Object theObject,
int targetSqlType,
int scale)
Sets the value of a specified parameter using a supplied object. |
void |
setShort(java.lang.String parameterName,
short theShort)
Sets the value of a specified parameter to a supplied short value. |
void |
setString(java.lang.String parameterName,
java.lang.String theString)
Sets the value of a specified parameter to a supplied String. |
void |
setTime(java.lang.String parameterName,
Time theTime)
Sets the value of the parameter named parameterName to the value of the supplied
java.sql.Time . |
void |
setTime(java.lang.String parameterName,
Time theTime,
java.util.Calendar cal)
Sets the value of the parameter named parameterName to the value of the supplied
java.sql.Time using the supplied Calendar. |
void |
setTimestamp(java.lang.String parameterName,
Timestamp theTimestamp)
Sets the value of a specified parameter to a supplied java.sql.Timestamp value. |
void |
setTimestamp(java.lang.String parameterName,
Timestamp theTimestamp,
java.util.Calendar cal)
Sets the value of a specified parameter to a supplied java.sql.Timestamp value, using the supplied Calendar. |
boolean |
wasNull()
Gets whether the value of the last OUT parameter read was SQL NULL. |
Methods inherited from interface oracle.adfnmc.java.sql.PreparedStatement |
---|
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream |
Methods inherited from interface oracle.adfnmc.java.sql.Statement |
---|
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout |
Method Detail |
---|
Array getArray(int parameterIndex) throws SQLException
ARRAY
parameter as a java.sql.Array.
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensArray getArray(java.lang.String parameterName) throws SQLException
parameterName
- the parameter of interest's name
java.sql.Array
containing the parameter value
SQLException
- if there is a problem accessing the databaseBlob getBlob(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensBlob getBlob(java.lang.String parameterName) throws SQLException
parameterName
- the name of the parameter
SQLException
- if a database error happensboolean getBoolean(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensboolean getBoolean(java.lang.String parameterName) throws SQLException
BIT
parameter as a boolean
parameterName
- the parameter of interest's name
boolean
representation of the value of the parameter. false
is returned if the
SQL value is NULL
.
SQLException
- if there is a problem accessing the databasebyte getByte(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensbyte getByte(java.lang.String parameterName) throws SQLException
TINYINT
parameter as a Java byte
.
parameterName
- the parameter of interest's name
byte
representation of the value of the parameter. 0
is returned if the SQL
value is NULL
.
SQLException
- if there is a problem accessing the databasebyte[] getBytes(int parameterIndex) throws SQLException
BINARY
or VARBINARY
parameter.
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if there is a problem accessing the databasebyte[] getBytes(java.lang.String parameterName) throws SQLException
BINARY
or VARBINARY
parameter.
parameterName
- the name of the parameter
SQLException
- if there is a problem accessing the databaseClob getClob(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensClob getClob(java.lang.String parameterName) throws SQLException
parameterName
- the name of the parameter
SQLException
- if a database error happensDate getDate(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensDate getDate(int parameterIndex, java.util.Calendar cal) throws SQLException
The JDBC driver uses the Calendar to create the Date using a particular timezone and locale. Default behaviour of the driver is to use the Java virtual machine default settings.
parameterIndex
- the parameter number index, where the first parameter has index 1cal
- the Calendar to use to construct the Date
SQLException
- if a database error happensDate getDate(java.lang.String parameterName) throws SQLException
parameterName
- the name of the parameter
SQLException
- if a database error happensDate getDate(java.lang.String parameterName, java.util.Calendar cal) throws SQLException
The JDBC driver uses the Calendar to create the Date using a particular timezone and locale. Default behaviour of the driver is to use the Java virtual machine default settings.
parameterName
- the parameter namecal
- used for creating the returned Date
SQLException
- if a database error happensdouble getDouble(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensdouble getDouble(java.lang.String parameterName) throws SQLException
parameterName
- the parameter name
double
. An SQL value of NULL
gets
represented as 0
(zero).
SQLException
- if there is a problem accessing the databasefloat getFloat(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensfloat getFloat(java.lang.String parameterName) throws SQLException
FLOAT
parameter as a Java float
.
parameterName
- the parameter name
float
. An SQL value of NULL
gets
represented as 0
(zero).
SQLException
- if there is a problem accessing the databaseint getInt(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensint getInt(java.lang.String parameterName) throws SQLException
parameterName
- the name of the parameter
SQLException
- if a database error happenslong getLong(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happenslong getLong(java.lang.String parameterName) throws SQLException
parameterName
- the name of the parameter
SQLException
- if a database error happensjava.lang.Object getObject(int parameterIndex) throws SQLException
Object
.
The object type returned is the JDBC type registered for the parameter with a registerOutParameter
call. If a parameter was registered as a java.sql.Types.OTHER
then it may hold abstract types that are
particular to the connected database.
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if there is a problem accessing the databasejava.lang.Object getObject(java.lang.String parameterName) throws SQLException
The object type returned is the JDBC type registered for the parameter with a registerOutParameter
call. If a parameter was registered as a java.sql.Types.OTHER
then it may hold abstract types that are
particular to the connected database.
parameterName
- the parameter name
Object
representation of the value of the parameter.
SQLException
- if there is a problem accessing the databaseRef getRef(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensRef getRef(java.lang.String parameterName) throws SQLException
parameterName
- the parameter name
java.sql.Ref
. A null
reference is
returned for a parameter value of SQL NULL
.
SQLException
- if there is a problem accessing the databaseshort getShort(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensshort getShort(java.lang.String parameterName) throws SQLException
SMALLINT
parameter as a short
parameterName
- the parameter name
short
. If the value is an SQL NULL
then 0
(zero) is returned.
SQLException
- if there is a problem accessing the databasejava.lang.String getString(int parameterIndex) throws SQLException
CHAR
, VARCHAR
or LONGVARCHAR
.
The string corresponding to a CHAR
of fixed length will be of identical length to the value in the
database inclusive of padding characters.
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if there is a problem accessing the databasejava.lang.String getString(java.lang.String parameterName) throws SQLException
CHAR
, VARCHAR
or LONGVARCHAR
.
The string corresponding to a CHAR
of fixed length will be of identical length to the value in the
database inclusive of padding characters.
parameterName
- the parameter name
SQLException
- if there is a problem accessing the databaseTime getTime(int parameterIndex) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1
SQLException
- if a database error happensTime getTime(int parameterIndex, java.util.Calendar cal) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has index 1cal
- the Calendar to use in constructing the Time.
SQLException
- if a database error happensTime getTime(java.lang.String parameterName) throws SQLException
TIME
parameter as a
parameterName
- the parameter name
java.sql.Time
with the parameter value. A null
reference is returned for an
SQL value of NULL
SQLException
- if a database error happensTime getTime(java.lang.String parameterName, java.util.Calendar cal) throws SQLException
parameterName
- the parameter namecal
- used for creating the returned Time
java.sql.Time
with the parameter value. A null
reference is returned for an SQL
value of NULL
SQLException
- if a database error happensTimestamp getTimestamp(int parameterIndex) throws SQLException
TIMESTAMP
value as a java.sql.Timestamp
.
parameterIndex
- the parameter number index, where the first parameter has index 1
java.sql.Timestamp
with the parameter value. A null
reference is returned
for an SQL value of NULL
SQLException
- if a database error happensTimestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws SQLException
TIMESTAMP
value as a java.sql.Timestamp
. The JDBC driver
uses the supplied Calendar
to handle specific timezones and locales when creating the result.
parameterIndex
- the parameter number index, where the first parameter has index 1cal
- used for creating the returned Timestamp
java.sql.Timestamp
with the parameter value. A null
reference is returned
for an SQL value of NULL
SQLException
- if a database error happensTimestamp getTimestamp(java.lang.String parameterName) throws SQLException
TIMESTAMP
value as a java.sql.Timestamp
.
parameterName
- the parameter name
java.sql.Timestamp
with the parameter value. A null
reference is returned
for an SQL value of NULL
SQLException
- if a database error happensTimestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws SQLException
TIMESTAMP
value as a java.sql.Timestamp
. The JDBC driver
uses the supplied Calendar
to handle specific timezones and locales when creating the result.
parameterName
- the parameter namecal
- used for creating the returned Timestamp
java.sql.Timestamp
with the parameter value. A null
reference is returned
for an SQL value of NULL
SQLException
- if a database error happensvoid registerOutParameter(int parameterIndex, int sqlType) throws SQLException
The Type defined by this method fixes the Java type that must be retrieved using the getter methods of CallableStatement. If a database specific type is expected for a parameter, the Type java.sql.Types.OTHER should be used. Note that there is another variant of this method for User Defined Types or a REF type.
parameterIndex
- the parameter number index, where the first parameter has index 1sqlType
- the JDBC type as defined by java.sql.Types. The JDBC types NUMERIC and DECIMAL should be defined using the
version of registerOutParameter
that takes a scale
parameter.
SQLException
- if a database error happensvoid registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException
The Type defined by this method fixes the Java type that must be retrieved using the getter methods of CallableStatement.
parameterIndex
- the parameter number index, where the first parameter has index 1sqlType
- the JDBC type as defined by java.sql.Types.scale
- the number of digits after the decimal point. Must be greater than or equal to 0.
SQLException
- if a database error happensvoid registerOutParameter(int paramIndex, int sqlType, java.lang.String typeName) throws SQLException
paramIndex
- the parameter number index, where the first parameter has index 1sqlType
- a JDBC type expressed as a constant from Types
typeName
- an SQL type name. For a REF type, this name should be the fully qualified name of the referenced type.
SQLException
- if a database error happensvoid registerOutParameter(java.lang.String parameterName, int sqlType) throws SQLException
The Type defined by this method fixes the Java type that must be retrieved using the getter methods of CallableStatement. If a database specific type is expected for a parameter, the Type java.sql.Types.OTHER should be used. Note that there is another variant of this method for User Defined Types or a REF type.
parameterName
- the parameter namesqlType
- a JDBC type expressed as a constant from Types
. Types NUMERIC and DECIMAL should be defined using
the variant of this method that takes a scale
parameter.
SQLException
- if a database error happensvoid registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws SQLException
The Type defined by this method fixes the Java type that must be retrieved using the getter methods of CallableStatement.
parameterName
- the parameter namesqlType
- a JDBC type expressed as a constant from Types
scale
- the number of digits after the decimal point. Must be greater than or equal to 0.
SQLException
- if a database error happensvoid registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws SQLException
parameterName
- the parameter namesqlType
- a JDBC type expressed as a constant from Types
typeName
- the fully qualified name of an SQL structured type. For a REF type, this name should be the fully
qualified name of the referenced type.
SQLException
- if a database error happensvoid setAsciiStream(java.lang.String parameterName, java.io.InputStream theInputStream, int length) throws SQLException
This is a good method for setting an SQL LONVARCHAR parameter where the length of the data is large. Data is read from the InputStream until end-of-file is reached or the specified number of bytes is copied.
parameterName
- the parameter nametheInputStream
- the ASCII InputStream carrying the data to update the parameter withlength
- the number of bytes in the InputStream to copy to the parameter
SQLException
- if a database error happensvoid setBinaryStream(java.lang.String parameterName, java.io.InputStream theInputStream, int length) throws SQLException
Use this method when a large amount of data needs to be set into a LONGVARBINARY parameter.
parameterName
- the name of the parametertheInputStream
- the binary InputStream carrying the data to update the parameterlength
- the number of bytes in the InputStream to copy to the parameter
SQLException
- if a database error happensvoid setBoolean(java.lang.String parameterName, boolean theBoolean) throws SQLException
parameterName
- the parameter nametheBoolean
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setByte(java.lang.String parameterName, byte theByte) throws SQLException
parameterName
- the parameter nametheByte
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setBytes(java.lang.String parameterName, byte[] theBytes) throws SQLException
VARBINARY
or else LONGVARBINARY
in the connected database.
parameterName
- the parameter nametheBytes
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws SQLException
parameterName
- the parameter namereader
- the new value with which to update the parameterlength
- a count of the characters contained in reader
SQLException
- if a database error happensvoid setDate(java.lang.String parameterName, Date theDate) throws SQLException
parameterName
- the parameter nametheDate
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setDate(java.lang.String parameterName, Date theDate, java.util.Calendar cal) throws SQLException
parameterName
- the parameter nametheDate
- the new value with which to update the parametercal
- a Calendar to use to construct the SQL DATE value
SQLException
- if a database error happensvoid setDouble(java.lang.String parameterName, double theDouble) throws SQLException
parameterName
- the parameter nametheDouble
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setFloat(java.lang.String parameterName, float theFloat) throws SQLException
parameterName
- the parameter nametheFloat
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setInt(java.lang.String parameterName, int theInt) throws SQLException
parameterName
- the parameter nametheInt
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setLong(java.lang.String parameterName, long theLong) throws SQLException
parameterName
- the parameter nametheLong
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setNull(java.lang.String parameterName, int sqlType) throws SQLException
parameterName
- the parameter namesqlType
- a JDBC type expressed as a constant from Types
SQLException
- if a database error happensvoid setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws SQLException
REF
or user
defined (e.g. STRUCT
, JAVA_OBJECT
etc).
For reasons of portability, the caller is expected to supply both the SQL Type code and Type name (which is just the parameter name if the type is user defined, or the name of the type being referenced if a REF).
parameterName
- the parameter namesqlType
- a JDBC type expressed as a constant from Types
typeName
- if the target parameter is a user defined type then this should contain the full type name
the fully qualified name of a UDT or REF type - ignored if the parameter is not a UDT.
SQLException
- if a database error happensvoid setObject(java.lang.String parameterName, java.lang.Object theObject) throws SQLException
theObject
is transformed to the corresponding SQL type according to the normal Java to SQL
mapping rules.
If the object's class implements the interface SQLData, the JDBC driver calls SQLData.writeSQL
to
write it to the SQL data stream. If theObject
implements any of the following interfaces then it is
the role of the driver to flow the value to the connected database using the appropriate SQL type :
parameterName
- the parameter nametheObject
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setObject(java.lang.String parameterName, java.lang.Object theObject, int targetSqlType) throws SQLException
The Object is converted to the given targetSqlType before it is sent to the database. If the object has a custom
mapping (its class implements the interface SQLData), the JDBC driver will call the method SQLData.writeSQL to
write it to the SQL data stream. If theObject
implements any of the following interfaces then it is
the role of the driver to flow the value to the connected database using the appropriate SQL type :
parameterName
- the parameter nametheObject
- the new value with which to update the parametertargetSqlType
- a JDBC type expressed as a constant from Types
SQLException
- if a database error happensvoid setObject(java.lang.String parameterName, java.lang.Object theObject, int targetSqlType, int scale) throws SQLException
The Object is converted to the given targetSqlType before it is sent to the database. If the object has a custom
mapping (its class implements the interface SQLData), the JDBC driver will call the method SQLData.writeSQL to
write it to the SQL data stream. If theObject
implements any of the following interfaces then it is
the role of the driver to flow the value to the connected database using the appropriate SQL type :
parameterName
- the parameter nametheObject
- the new value with which to update the parametertargetSqlType
- a JDBC type expressed as a constant from Types
scale
- where applicable, the number of digits after the decimal point.
SQLException
- if a database error happensvoid setShort(java.lang.String parameterName, short theShort) throws SQLException
parameterName
- the name of the parametertheShort
- a short value to update the parameter
SQLException
- if a database error happensvoid setString(java.lang.String parameterName, java.lang.String theString) throws SQLException
parameterName
- the name of the parametertheString
- a String value to update the parameter
SQLException
- if a database error happensvoid setTime(java.lang.String parameterName, Time theTime) throws SQLException
parameterName
to the value of the supplied
java.sql.Time
.
parameterName
- the parameter nametheTime
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setTime(java.lang.String parameterName, Time theTime, java.util.Calendar cal) throws SQLException
parameterName
to the value of the supplied
java.sql.Time
using the supplied Calendar.
The driver uses the supplied Calendar to create the SQL TIME value, which allows it to use a custom timezone - otherwise the driver uses the default timezone of the Java virtual machine.
parameterName
- the parameter nametheTime
- the new value with which to update the parametercal
- used for creating the new SQL TIME
value
SQLException
- if a database error happensvoid setTimestamp(java.lang.String parameterName, Timestamp theTimestamp) throws SQLException
parameterName
- the parameter nametheTimestamp
- the new value with which to update the parameter
SQLException
- if a database error happensvoid setTimestamp(java.lang.String parameterName, Timestamp theTimestamp, java.util.Calendar cal) throws SQLException
The driver uses the supplied Calendar to create the SQL TIMESTAMP value, which allows it to use a custom timezone - otherwise the driver uses the default timezone of the Java virtual machine.
parameterName
- the parameter nametheTimestamp
- the new value with which to update the parametercal
- used for creating the new SQL TIME
value
SQLException
- if a database error happensboolean wasNull() throws SQLException
SQLException
- if a database error happens
|
Oracle Fusion Middleware Java API Reference for Oracle ADF Mobile Client 11g Release 1 (11.1.1) E17503-02 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |