oracle.jdbc
Interface OracleResultSet

public abstract interface OracleResultSet
extends java.sql.ResultSet

Fields inherited from class java.sql.ResultSet
CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE
 
Method Summary
TypeMethod
 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.
 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 paramIdx)
          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 paramIdx)
          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 paramIdx)
          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, java.sql.Array x)
          Oracle extension.
 void updateARRAY(int columnIndex, ARRAY x)
          Oracle extension.
 void updateArray(java.lang.String columnName, java.sql.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, java.sql.Blob x)
          Oracle extension.
 void updateBLOB(int columnIndex, BLOB x)
          Oracle extension.
 void updateBlob(java.lang.String columnName, java.sql.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, java.sql.Clob x)
          Oracle extension.
 void updateCLOB(int columnIndex, CLOB x)
          Oracle extension.
 void updateClob(java.lang.String columnName, java.sql.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 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, java.sql.Ref x)
          Oracle extension.
 void updateREF(int columnIndex, REF x)
          Oracle extension.
 void updateRef(java.lang.String columnName, java.sql.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.
 
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, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, 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.

getTIMESTAMP

public TIMESTAMP getTIMESTAMP(int paramIdx)
                       throws java.sql.SQLException
Obtain an oralce.sql.TIMESTAMP value from the ResultSet.
Parameters:
paramIdx - 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 paramIdx)
                           throws java.sql.SQLException
Obtain an oralce.sql.TIMESTAMPTZ value from the ResultSet.
Parameters:
paramIdx - 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 paramIdx)
                             throws java.sql.SQLException
Obtain an oralce.sql.TIMESTAMPLTZ value from the ResultSet.
Parameters:
paramIdx - 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,
                        java.sql.Array x)
                 throws java.sql.SQLException
Oracle extension. Updates a column with an 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(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,
                        java.sql.Array x)
                 throws java.sql.SQLException
Oracle extension. Updates a column with an 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

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 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(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 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,
                       java.sql.Blob x)
                throws java.sql.SQLException
Oracle extension. Updates a column with an 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(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,
                       java.sql.Blob x)
                throws java.sql.SQLException
Oracle extension. Updates a column with an 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

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,
                       java.sql.Clob x)
                throws java.sql.SQLException
Oracle extension. Updates a column with an 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(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,
                       java.sql.Clob x)
                throws java.sql.SQLException
Oracle extension. Updates a column with an 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

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

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,
                      java.sql.Ref x)
               throws java.sql.SQLException
Oracle extension. Updates a column with an 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(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,
                      java.sql.Ref x)
               throws java.sql.SQLException
Oracle extension. Updates a column with an 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

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