oracle.jdbc
Interface OracleResultSet

All Superinterfaces:

java.sql.ResultSet

public interface OracleResultSet

extends java.sql.ResultSet

Field Summary

Fields inherited from interface java.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Method Summary

ARRAY	getARRAY(int columnIndex) Oracle extension.
ARRAY	getARRAY(java.lang.String columnName) Oracle extension.
BFILE	getBfile(int columnIndex) Oracle extension.
BFILE	getBFILE(int columnIndex) Oracle extension.
BFILE	getBfile(java.lang.String columnName) Oracle extension.
BFILE	getBFILE(java.lang.String columnName) Oracle extension.
BLOB	getBLOB(int columnIndex) Oracle extension.
BLOB	getBLOB(java.lang.String columnName) Oracle extension.
CHAR	getCHAR(int columnIndex) Oracle extension.
CHAR	getCHAR(java.lang.String columnName) Oracle extension.
CLOB	getCLOB(int columnIndex) Oracle extension.
CLOB	getCLOB(java.lang.String columnName) Oracle extension.
java.sql.ResultSet	getCursor(int columnIndex) Oracle extension.
java.sql.ResultSet	getCursor(java.lang.String columnName) Oracle extension.
CustomDatum	getCustomDatum(int columnIndex, CustomDatumFactory factory) Deprecated.
CustomDatum	getCustomDatum(java.lang.String columnName, CustomDatumFactory factory) Deprecated.
DATE	getDATE(int columnIndex) Oracle extension.
DATE	getDATE(java.lang.String columnName) Oracle extension.
INTERVALDS	getINTERVALDS(int columnIndex) Obtain an oralce.sql.INTERVALDS value from the ResultSet.
INTERVALDS	getINTERVALDS(java.lang.String columnName) Obtain an oralce.sql.INTERVALDS value from the ResultSet.
INTERVALYM	getINTERVALYM(int columnIndex) Obtain an oralce.sql.INTERVALYM value from the ResultSet.
INTERVALYM	getINTERVALYM(java.lang.String columnName) Obtain an oralce.sql.INTERVALYM value from the ResultSet.
NUMBER	getNUMBER(int columnIndex) Oracle extension.
NUMBER	getNUMBER(java.lang.String columnName) Oracle extension.
OPAQUE	getOPAQUE(int columnIndex) Oracle extension.
OPAQUE	getOPAQUE(java.lang.String columnName) Oracle extension.
Datum	getOracleObject(int columnIndex) Oracle extension.
Datum	getOracleObject(java.lang.String columnName) Oracle extension.
ORAData	getORAData(int columnIndex, ORADataFactory factory) Oracle extension.
ORAData	getORAData(java.lang.String columnName, ORADataFactory factory) Oracle extension.
RAW	getRAW(int columnIndex) Oracle extension.
RAW	getRAW(java.lang.String columnName) Oracle extension.
REF	getREF(int columnIndex) Oracle extension.
REF	getREF(java.lang.String columnName) Oracle extension.
ROWID	getROWID(int columnIndex) Oracle extension.
ROWID	getROWID(java.lang.String columnName) Oracle extension.
STRUCT	getSTRUCT(int columnIndex) Oracle extension.
STRUCT	getSTRUCT(java.lang.String columnName) Oracle extension.
TIMESTAMP	getTIMESTAMP(int columnIndex) Obtain an oralce.sql.TIMESTAMP value from the ResultSet.
TIMESTAMP	getTIMESTAMP(java.lang.String colName) Obtain an oralce.sql.TIMESTAMP value from the ResultSet.
TIMESTAMPLTZ	getTIMESTAMPLTZ(int columnIndex) Obtain an oralce.sql.TIMESTAMPLTZ value from the ResultSet.
TIMESTAMPLTZ	getTIMESTAMPLTZ(java.lang.String colName) Obtain an oralce.sql.TIMESTAMPLTZ value from the ResultSet.
TIMESTAMPTZ	getTIMESTAMPTZ(int columnIndex) Obtain an oralce.sql.TIMESTAMPTZ value from the ResultSet.
TIMESTAMPTZ	getTIMESTAMPTZ(java.lang.String colName) Obtain an oralce.sql.TIMESTAMPTZ value from the ResultSet.
void	updateARRAY(int columnIndex, ARRAY x) Oracle extension.
void	updateARRAY(java.lang.String columnName, ARRAY x) Oracle extension.
void	updateBfile(int columnIndex, BFILE X) Oracle extension.
void	updateBFILE(int columnIndex, BFILE x) Oracle extension.
void	updateBfile(java.lang.String columnName, BFILE x) Oracle extension.
void	updateBFILE(java.lang.String columnName, BFILE x) Oracle extension.
void	updateBLOB(int columnIndex, BLOB x) Oracle extension.
void	updateBLOB(java.lang.String columnName, BLOB x) Oracle extension.
void	updateCHAR(int columnIndex, CHAR x) Oracle extension.
void	updateCHAR(java.lang.String columnName, CHAR x) Oracle extension.
void	updateCLOB(int columnIndex, CLOB x) Oracle extension.
void	updateCLOB(java.lang.String columnName, CLOB x) Oracle extension.
void	updateCustomDatum(int columnIndex, CustomDatum x) Deprecated.
void	updateCustomDatum(java.lang.String columnName, CustomDatum x) Deprecated.
void	updateDATE(int columnIndex, DATE x) Oracle extension.
void	updateDATE(java.lang.String columnName, DATE x) Oracle extension.
void	updateINTERVALDS(int columnIndex, INTERVALDS x) Oracle extension.
void	updateINTERVALYM(int columnIndex, INTERVALYM x) Oracle extension.
void	updateNUMBER(int columnIndex, NUMBER x) Oracle extension.
void	updateNUMBER(java.lang.String columnName, NUMBER x) Oracle extension.
void	updateOracleObject(int columnIndex, Datum x) Oracle extension.
void	updateOracleObject(java.lang.String columnName, Datum x) Oracle extension.
void	updateORAData(int columnIndex, ORAData x) Oracle extension.
void	updateORAData(java.lang.String columnName, ORAData x) Oracle extension.
void	updateRAW(int columnIndex, RAW x) Oracle extension.
void	updateRAW(java.lang.String columnName, RAW x) Oracle extension.
void	updateREF(int columnIndex, REF x) Oracle extension.
void	updateREF(java.lang.String columnName, REF x) Oracle extension.
void	updateROWID(int columnIndex, ROWID x) Oracle extension.
void	updateROWID(java.lang.String columnName, ROWID x) Oracle extension.
void	updateSTRUCT(int columnIndex, STRUCT x) Oracle extension.
void	updateSTRUCT(java.lang.String columnName, STRUCT x) Oracle extension.
void	updateTIMESTAMP(int columnIndex, TIMESTAMP x) Oracle extension.
void	updateTIMESTAMPLTZ(int columnIndex, TIMESTAMPLTZ x) Oracle extension.
void	updateTIMESTAMPTZ(int columnIndex, TIMESTAMPTZ x) Oracle extension.

Methods inherited from interface java.sql.ResultSet

absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getInt, getInt, getLong, getLong, getMetaData, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getShort, getShort, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Method Detail

getARRAY

public ARRAY getARRAY(int columnIndex)
               throws java.sql.SQLException

Oracle extension. Get the column value as a ARRAY. An ARRAY instance maps to a Nested Table or VARRAY value in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.ARRAY

Throws:

java.sql.SQLException - if a database access error occurs.

getARRAY

public ARRAY getARRAY(java.lang.String columnName)
               throws java.sql.SQLException

Oracle extension. Get the column value as a ARRAY. An ARRAY instance maps to a Nested Table or VARRAY value in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.ARRAY

Throws:

java.sql.SQLException - if a database access error occurs.

getBfile

public BFILE getBfile(int columnIndex)
               throws java.sql.SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.BFILE

Throws:

java.sql.SQLException - if a database access error occurs.

getBFILE

public BFILE getBFILE(int columnIndex)
               throws java.sql.SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.BFILE

Throws:

java.sql.SQLException - if a database access error occurs.

getBfile

public BFILE getBfile(java.lang.String columnName)
               throws java.sql.SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.BFILE

Throws:

java.sql.SQLException - if a database access error occurs.

getBFILE

public BFILE getBFILE(java.lang.String columnName)
               throws java.sql.SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.BFILE

Throws:

java.sql.SQLException - if a database access error occurs.

getBLOB

public BLOB getBLOB(int columnIndex)
             throws java.sql.SQLException

Oracle extension. Get the column value as a BLOB (unstructured binary data). BLOB data is accessed and referenced by using a locator which is stored in the database table and points to the BLOB data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.BLOB

Throws:

java.sql.SQLException - if a database access error occurs.

getBLOB

public BLOB getBLOB(java.lang.String columnName)
             throws java.sql.SQLException

Oracle extension. Get the column value as a BLOB (unstructured binary data). BLOB data is accessed and referenced by using a locator which is stored in the database table and points to the BLOB data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.BLOB

Throws:

java.sql.SQLException - if a database access error occurs.

getCHAR

public CHAR getCHAR(int columnIndex)
             throws java.sql.SQLException

Oracle extension. Get the column as a CHAR value. CHAR values retain the same same representation as they have in the database, so there can be no loss of information through conversion. While the vast majority of characters in the various Oracle NLS character sets are represented in the Unicode character set used by Java there are a very small number that are not. Additionally, JDBC does not have to perform any conversion when getting character data as CHAR, so getCHAR is slightly efficient than getString.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.CHAR

Throws:

java.sql.SQLException - if a database access error occurs.

getCHAR

public CHAR getCHAR(java.lang.String columnName)
             throws java.sql.SQLException

Oracle extension. Get the column as a CHAR value. CHAR values retain the same same representation as they have in the database, so there can be no loss of information through conversion. While the vast majority of characters in the various Oracle NLS character sets are represented in the Unicode character set used by Java there are a very small number that are not. Additionally, JDBC does not have to perform any conversion when getting character data as CHAR, so getCHAR is slightly efficient than getString.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.CHAR

Throws:

java.sql.SQLException - if a database access error occurs.

getCLOB

public CLOB getCLOB(int columnIndex)
             throws java.sql.SQLException

Oracle extension. Get the column value as a CLOB (single-byte character data). CLOB data is accessed and referenced by using a locator which is stored in the database table and points to the CLOB data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.CLOB

Throws:

java.sql.SQLException - if a database access error occurs.

getCLOB

public CLOB getCLOB(java.lang.String columnName)
             throws java.sql.SQLException

Oracle extension. Get the column value as a CLOB (single-byte character data). CLOB data is accessed and referenced by using a locator which is stored in the database table and points to the CLOB data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.CLOB

Throws:

java.sql.SQLException - if a database access error occurs.

getOPAQUE

public OPAQUE getOPAQUE(int columnIndex)
                 throws java.sql.SQLException

Oracle extension. Get the column value as an OPAQUE.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.OPAQUE

Throws:

java.sql.SQLException - if a database access error occurs.

getOPAQUE

public OPAQUE getOPAQUE(java.lang.String columnName)
                 throws java.sql.SQLException

Oracle extension. Get the column value as an OPAQUE.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.OPAQUE

Throws:

java.sql.SQLException - if a database access error occurs.

getINTERVALYM

public INTERVALYM getINTERVALYM(int columnIndex)
                         throws java.sql.SQLException

Obtain an oralce.sql.INTERVALYM value from the ResultSet.

Parameters:

columnIndex - parameter number.

Returns:

the obtained value.

Throws:

java.sql.SQLException - if an error occurred.

Since:

9i

getINTERVALYM

public INTERVALYM getINTERVALYM(java.lang.String columnName)
                         throws java.sql.SQLException

Obtain an oralce.sql.INTERVALYM value from the ResultSet.

Returns:

the obtained value.

Throws:

java.sql.SQLException - if an error occurred.

Since:

9i

getINTERVALDS

public INTERVALDS getINTERVALDS(int columnIndex)
                         throws java.sql.SQLException

Obtain an oralce.sql.INTERVALDS value from the ResultSet.

Parameters:

columnIndex - parameter number.

Returns:

the obtained value.

Throws:

java.sql.SQLException - if an error occurred.

Since:

10i

getINTERVALDS

public INTERVALDS getINTERVALDS(java.lang.String columnName)
                         throws java.sql.SQLException

Obtain an oralce.sql.INTERVALDS value from the ResultSet.

Returns:

the obtained value.

Throws:

java.sql.SQLException - if an error occurred.

Since:

10i

getTIMESTAMP

public TIMESTAMP getTIMESTAMP(int columnIndex)
                       throws java.sql.SQLException

Obtain an oralce.sql.TIMESTAMP value from the ResultSet.

Parameters:

columnIndex - parameter number.

Returns:

the obtained value.

Throws:

java.sql.SQLException - if an error occurred.

Since:

9i

getTIMESTAMP

public TIMESTAMP getTIMESTAMP(java.lang.String colName)
                       throws java.sql.SQLException

Obtain an oralce.sql.TIMESTAMP value from the ResultSet.

Parameters:

colName - column name.

Returns:

the obtained value.

Throws:

java.sql.SQLException - if an error occurred.

Since:

9i

getTIMESTAMPTZ

public TIMESTAMPTZ getTIMESTAMPTZ(int columnIndex)
                           throws java.sql.SQLException

Obtain an oralce.sql.TIMESTAMPTZ value from the ResultSet.

Parameters:

columnIndex - parameter number.

Returns:

the obtained value.

Throws:

java.sql.SQLException - if an error occurred.

Since:

9i

getTIMESTAMPTZ

public TIMESTAMPTZ getTIMESTAMPTZ(java.lang.String colName)
                           throws java.sql.SQLException

Obtain an oralce.sql.TIMESTAMPTZ value from the ResultSet.

Parameters:

colName - column name.

Returns:

the obtained value.

Throws:

java.sql.SQLException - if an error occurred.

Since:

9i

getTIMESTAMPLTZ

public TIMESTAMPLTZ getTIMESTAMPLTZ(int columnIndex)
                             throws java.sql.SQLException

Obtain an oralce.sql.TIMESTAMPLTZ value from the ResultSet.

Parameters:

columnIndex - parameter number.

Returns:

the obtained value.

Throws:

java.sql.SQLException - if an error occurred.

Since:

9i

getTIMESTAMPLTZ

public TIMESTAMPLTZ getTIMESTAMPLTZ(java.lang.String colName)
                             throws java.sql.SQLException

Obtain an oralce.sql.TIMESTAMPLTZ value from the ResultSet.

Parameters:

colName - column name.

Returns:

the obtained value.

Throws:

java.sql.SQLException - if an error occurred.

Since:

9i

getCursor

public java.sql.ResultSet getCursor(int columnIndex)
                             throws java.sql.SQLException

Oracle extension. Get the REFCURSOR value of the column as a ResultSet.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the REFCURSOR column value as a ResultSet

Throws:

java.sql.SQLException - if a database access error occurs

getCursor

public java.sql.ResultSet getCursor(java.lang.String columnName)
                             throws java.sql.SQLException

Oracle extension. Get the REFCURSOR value of the column as a ResultSet.

Parameters:

columnName - the name of the column

Returns:

the REFCURSOR column value as a ResultSet

Throws:

java.sql.SQLException - if a database access error occurs

getCustomDatum

public CustomDatum getCustomDatum(int columnIndex,
                                  CustomDatumFactory factory)
                           throws java.sql.SQLException

Deprecated.

Oracle extension. Get the column value as an instance of a subclass of CustomDatum. Which subclass is determined by the factory parameter.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

factory - CustomDatumFactory used to materialize the column value

Returns:

the column value as a CustomDatum; if the value is SQL NULL, the result is null

Throws:

java.sql.SQLException - if a database access error occurs.

getORAData

public ORAData getORAData(int columnIndex,
                          ORADataFactory factory)
                   throws java.sql.SQLException

Oracle extension. Get the column value as an instance of a subclass of ORAData. Which subclass is determined by the factory parameter.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

factory - ORADataFactory used to materialize the column value

Returns:

the column value as a ORAData; if the value is SQL NULL, the result is null

Throws:

java.sql.SQLException - if a database access error occurs.

getCustomDatum

public CustomDatum getCustomDatum(java.lang.String columnName,
                                  CustomDatumFactory factory)
                           throws java.sql.SQLException

Deprecated.

Oracle extension. Get the column value as an instance of a subclass of CustomDatum. Which subclass is determined by the factory parameter.

Parameters:

columnName - the name of the column

factory - CustomDatumFactory used to materialize the column value

Returns:

the column value as a CustomDatum; if the value is SQL NULL, the result is null

Throws:

java.sql.SQLException - if a database access error occurs.

getORAData

public ORAData getORAData(java.lang.String columnName,
                          ORADataFactory factory)
                   throws java.sql.SQLException

Oracle extension. Get the column value as an instance of a subclass of ORAData. Which subclass is determined by the factory parameter.

Parameters:

columnName - the name of the column

factory - ORADataFactory used to materialize the column value

Returns:

the column value as a ORAData; if the value is SQL NULL, the result is null

Throws:

java.sql.SQLException - if a database access error occurs.

getDATE

public DATE getDATE(int columnIndex)
             throws java.sql.SQLException

Oracle extension. Get the column value as a DATE.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.DATE

Throws:

java.sql.SQLException - if a database access error occurs.

getDATE

public DATE getDATE(java.lang.String columnName)
             throws java.sql.SQLException

Oracle extension. Get the column value as a DATE.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.DATE

Throws:

java.sql.SQLException - if a database access error occurs.

getNUMBER

public NUMBER getNUMBER(int columnIndex)
                 throws java.sql.SQLException

Oracle extension. Get the column value as a NUMBER. NUMBER values have the same representation as Oracle numbers in the database, thus they have exactly the same value. Getting numeric values as other types can result in very slightly different values due to the difference in representation. Additionally, JDBC does not have to do any conversion when using getNUMBER and so is more efficient.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.NUMBER

Throws:

java.sql.SQLException - if a database access error occurs.

getNUMBER

public NUMBER getNUMBER(java.lang.String columnName)
                 throws java.sql.SQLException

Oracle extension. Get the column value as a NUMBER. NUMBER values have the same representation as Oracle numbers in the database, thus they have exactly the same value. Getting numeric values as other types can result in very slightly different values due to the difference in representation. Additionally, JDBC does not have to do any conversion when using getNUMBER and so is more efficient.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.NUMBER

Throws:

java.sql.SQLException - if a database access error occurs.

getOracleObject

public Datum getOracleObject(int columnIndex)
                      throws java.sql.SQLException

Oracle extension. Get the column value as the appropriate oracle.sql. type. This differs from getObject in that getObject returns the appropriate jdbc.sql. type. The Oracle specific types in oracle.sql more closely model the underlying Oracle database types, so there is no possible loss of information due to conversion and slightly greater efficiency.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as the appropriate oracle.sql. type; if the value is SQL NULL, the result is null

Throws:

java.sql.SQLException - if a database access error occurs.

getOracleObject

public Datum getOracleObject(java.lang.String columnName)
                      throws java.sql.SQLException

Oracle extension. Get the column value as the appropriate oracle.sql. type. This differs from getObject in that getObject returns the appropriate jdbc.sql. type. The Oracle specific types in oracle.sql more closely model the underlying Oracle database types possible loss of information due to conversion and slightly greater efficiency.

Parameters:

columnName - the name of the column

Returns:

the column value as the appropriate oracle.sql. type; if the value is SQL NULL, the result is null

Throws:

java.sql.SQLException - if a database access error occurs.

getRAW

public RAW getRAW(int columnIndex)
           throws java.sql.SQLException

Oracle extension. Get the column value as a RAW. A RAW instance maps to a RAW or LONG RAW value in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.RAW

Throws:

java.sql.SQLException - if a database access error occurs.

getRAW

public RAW getRAW(java.lang.String columnName)
           throws java.sql.SQLException

Oracle extension. Get the column value as a RAW. A RAW instance maps to a RAW or LONG RAW value in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.RAW

Throws:

java.sql.SQLException - if a database access error occurs.

getREF

public REF getREF(int columnIndex)
           throws java.sql.SQLException

Oracle extension. Get the column value as a REF. A REF instance maps to a REF (to a row or concreated object) value in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.REF

Throws:

java.sql.SQLException - if a database access error occurs.

getREF

public REF getREF(java.lang.String columnName)
           throws java.sql.SQLException

Oracle extension. Get the column value as a REF. A REF instance maps to a REF (to a row or concreated object) value in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.REF

Throws:

java.sql.SQLException - if a database acc

getROWID

public ROWID getROWID(int columnIndex)
               throws java.sql.SQLException

Oracle extension. Get the ROWID column value as ROWID.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the ROWID column value as an oracle.sql.ROWID

Throws:

java.sql.SQLException - if a database access error occurs.

getROWID

public ROWID getROWID(java.lang.String columnName)
               throws java.sql.SQLException

Oracle extension. Get the ROWID column value as ROWID.

Parameters:

columnName - the name of the column

Returns:

the ROWID column value as an oracle.sql.ROWID

Throws:

java.sql.SQLException - if a database access error occurs.

getSTRUCT

public STRUCT getSTRUCT(int columnIndex)
                 throws java.sql.SQLException

Oracle extension. Get the column value as a STRUCT. A STRUCT instance maps to a structured data type instance in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.STRUCT

Throws:

java.sql.SQLException - if a database access error occurs.

See Also:

getORAData

getSTRUCT

public STRUCT getSTRUCT(java.lang.String columnName)
                 throws java.sql.SQLException

Oracle extension. Get the column value as a STRUCT. A STRUCT instance maps to a structured data type instance in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.STRUCT

Throws:

java.sql.SQLException - if a database access error occurs.

See Also:

getORAData

updateARRAY

public void updateARRAY(int columnIndex,
                        ARRAY x)
                 throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.ARRAY value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateARRAY

public void updateARRAY(java.lang.String columnName,
                        ARRAY x)
                 throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.ARRAY value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateBfile

public void updateBfile(int columnIndex,
                        BFILE X)
                 throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.BFILE value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Throws:

java.sql.SQLException - if a database access error occurs

updateBFILE

public void updateBFILE(int columnIndex,
                        BFILE x)
                 throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.BFILE value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateBfile

public void updateBfile(java.lang.String columnName,
                        BFILE x)
                 throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.BFILE value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateBFILE

public void updateBFILE(java.lang.String columnName,
                        BFILE x)
                 throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.BFILE value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateBLOB

public void updateBLOB(int columnIndex,
                       BLOB x)
                throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.BLOB value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateBLOB

public void updateBLOB(java.lang.String columnName,
                       BLOB x)
                throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.BLOB value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateCHAR

public void updateCHAR(int columnIndex,
                       CHAR x)
                throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.CHAR value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateCHAR

public void updateCHAR(java.lang.String columnName,
                       CHAR x)
                throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.CHAR value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateCLOB

public void updateCLOB(int columnIndex,
                       CLOB x)
                throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.CLOB value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateCLOB

public void updateCLOB(java.lang.String columnName,
                       CLOB x)
                throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.CLOB value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateCustomDatum

public void updateCustomDatum(int columnIndex,
                              CustomDatum x)
                       throws java.sql.SQLException

Deprecated.

Oracle extension. Updates a column with an CustomDatum value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateORAData

public void updateORAData(int columnIndex,
                          ORAData x)
                   throws java.sql.SQLException

Oracle extension. Updates a column with an ORAData value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateCustomDatum

public void updateCustomDatum(java.lang.String columnName,
                              CustomDatum x)
                       throws java.sql.SQLException

Deprecated.

Oracle extension. Updates a column with an CustomDatum value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateORAData

public void updateORAData(java.lang.String columnName,
                          ORAData x)
                   throws java.sql.SQLException

Oracle extension. Updates a column with an ORAData value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateDATE

public void updateDATE(int columnIndex,
                       DATE x)
                throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.DATE value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateDATE

public void updateDATE(java.lang.String columnName,
                       DATE x)
                throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.DATE value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateINTERVALYM

public void updateINTERVALYM(int columnIndex,
                             INTERVALYM x)
                      throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.INTERVALYM value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateINTERVALDS

public void updateINTERVALDS(int columnIndex,
                             INTERVALDS x)
                      throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.INTERVALDS value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateTIMESTAMP

public void updateTIMESTAMP(int columnIndex,
                            TIMESTAMP x)
                     throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.TIMESTAMP value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateTIMESTAMPTZ

public void updateTIMESTAMPTZ(int columnIndex,
                              TIMESTAMPTZ x)
                       throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.TIMESTAMPTZ value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateTIMESTAMPLTZ

public void updateTIMESTAMPLTZ(int columnIndex,
                               TIMESTAMPLTZ x)
                        throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.TIMESTAMPLTZ value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateNUMBER

public void updateNUMBER(int columnIndex,
                         NUMBER x)
                  throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.NUMBER value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateNUMBER

public void updateNUMBER(java.lang.String columnName,
                         NUMBER x)
                  throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.NUMBER value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateOracleObject

public void updateOracleObject(int columnIndex,
                               Datum x)
                        throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.xxx value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateOracleObject

public void updateOracleObject(java.lang.String columnName,
                               Datum x)
                        throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.xxx value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateRAW

public void updateRAW(int columnIndex,
                      RAW x)
               throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.RAW value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateRAW

public void updateRAW(java.lang.String columnName,
                      RAW x)
               throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.RAW value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateREF

public void updateREF(int columnIndex,
                      REF x)
               throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.REF value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateREF

public void updateREF(java.lang.String columnName,
                      REF x)
               throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.REF value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateROWID

public void updateROWID(int columnIndex,
                        ROWID x)
                 throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.ROWID value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateROWID

public void updateROWID(java.lang.String columnName,
                        ROWID x)
                 throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.ROWID value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateSTRUCT

public void updateSTRUCT(int columnIndex,
                         STRUCT x)
                  throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.STRUCT value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs

updateSTRUCT

public void updateSTRUCT(java.lang.String columnName,
                         STRUCT x)
                  throws java.sql.SQLException

Oracle extension. Updates a column with an oracle.sql.STRUCT value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws:

java.sql.SQLException - if a database access error occurs