Package oracle.jdbc

Interface OracleResultSet

  • All Superinterfaces:
    AutoCloseable, ResultSet, Wrapper

    public interface OracleResultSet
    extends ResultSet
    A table of data representing a database result set, which is usually generated by executing a statement that queries the database.
  • <section role="region">
    • Method Detail

      • getARRAY

        ARRAY getARRAY​(int columnIndex)
                throws 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:
        SQLException - if a database access error occurs.
      • getARRAY

        ARRAY getARRAY​(String columnName)
                throws 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:
        SQLException - if a database access error occurs.
      • getBfile

        BFILE getBfile​(int columnIndex)
                throws 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:
        SQLException - if a database access error occurs.
      • getBFILE

        BFILE getBFILE​(int columnIndex)
                throws 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:
        SQLException - if a database access error occurs.
      • getBfile

        BFILE getBfile​(String columnName)
                throws 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:
        SQLException - if a database access error occurs.
      • getBFILE

        BFILE getBFILE​(String columnName)
                throws 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:
        SQLException - if a database access error occurs.
      • getBLOB

        BLOB getBLOB​(int columnIndex)
              throws 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:
        SQLException - if a database access error occurs.
      • getBLOB

        BLOB getBLOB​(String columnName)
              throws 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:
        SQLException - if a database access error occurs.
      • getCHAR

        CHAR getCHAR​(int columnIndex)
              throws 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:
        SQLException - if a database access error occurs.
      • getCHAR

        CHAR getCHAR​(String columnName)
              throws 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:
        SQLException - if a database access error occurs.
      • getCLOB

        CLOB getCLOB​(int columnIndex)
              throws 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:
        SQLException - if a database access error occurs.
      • getCLOB

        CLOB getCLOB​(String columnName)
              throws 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:
        SQLException - if a database access error occurs.
      • getOPAQUE

        OPAQUE getOPAQUE​(int columnIndex)
                  throws 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:
        SQLException - if a database access error occurs.
      • getOPAQUE

        OPAQUE getOPAQUE​(String columnName)
                  throws 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:
        SQLException - if a database access error occurs.
      • getINTERVALYM

        INTERVALYM getINTERVALYM​(int columnIndex)
                          throws SQLException
        Obtain an oracle.sql.INTERVALYM value from the ResultSet.
        Parameters:
        columnIndex - parameter number.
        Returns:
        the obtained value.
        Throws:
        SQLException - if an error occurred.
        Since:
        9i
      • getINTERVALYM

        INTERVALYM getINTERVALYM​(String columnName)
                          throws SQLException
        Obtain an oracle.sql.INTERVALYM value from the ResultSet.
        Parameters:
        columnName - column name.
        Returns:
        the obtained value.
        Throws:
        SQLException - if an error occurred.
        Since:
        9i
      • getINTERVALDS

        INTERVALDS getINTERVALDS​(int columnIndex)
                          throws SQLException
        Obtain an oracle.sql.INTERVALDS value from the ResultSet.
        Parameters:
        columnIndex - parameter number.
        Returns:
        the obtained value.
        Throws:
        SQLException - if an error occurred.
        Since:
        10i
      • getINTERVALDS

        INTERVALDS getINTERVALDS​(String columnName)
                          throws SQLException
        Obtain an oracle.sql.INTERVALDS value from the ResultSet.
        Parameters:
        columnName - column name.
        Returns:
        the obtained value.
        Throws:
        SQLException - if an error occurred.
        Since:
        10i
      • getTIMESTAMP

        TIMESTAMP getTIMESTAMP​(int columnIndex)
                        throws SQLException
        Obtain an oracle.sql.TIMESTAMP value from the ResultSet.
        Parameters:
        columnIndex - parameter number.
        Returns:
        the obtained value.
        Throws:
        SQLException - if an error occurred.
        Since:
        9i
      • getTIMESTAMP

        TIMESTAMP getTIMESTAMP​(String columnName)
                        throws SQLException
        Obtain an oracle.sql.TIMESTAMP value from the ResultSet.
        Parameters:
        columnName - column name.
        Returns:
        the obtained value.
        Throws:
        SQLException - if an error occurred.
        Since:
        9i
      • getTIMESTAMPTZ

        TIMESTAMPTZ getTIMESTAMPTZ​(int columnIndex)
                            throws SQLException
        Obtain an oracle.sql.TIMESTAMPTZ value from the ResultSet.
        Parameters:
        columnIndex - parameter number.
        Returns:
        the obtained value.
        Throws:
        SQLException - if an error occurred.
        Since:
        9i
      • getTIMESTAMPTZ

        TIMESTAMPTZ getTIMESTAMPTZ​(String columnName)
                            throws SQLException
        Obtain an oracle.sql.TIMESTAMPTZ value from the ResultSet.
        Parameters:
        columnName - column name.
        Returns:
        the obtained value.
        Throws:
        SQLException - if an error occurred.
        Since:
        9i
      • getTIMESTAMPLTZ

        TIMESTAMPLTZ getTIMESTAMPLTZ​(int columnIndex)
                              throws SQLException
        Obtain an oracle.sql.TIMESTAMPLTZ value from the ResultSet.
        Parameters:
        columnIndex - parameter number.
        Returns:
        the obtained value.
        Throws:
        SQLException - if an error occurred.
        Since:
        9i
      • getTIMESTAMPLTZ

        TIMESTAMPLTZ getTIMESTAMPLTZ​(String columnName)
                              throws SQLException
        Obtain an oracle.sql.TIMESTAMPLTZ value from the ResultSet.
        Parameters:
        columnName - column name.
        Returns:
        the obtained value.
        Throws:
        SQLException - if an error occurred.
        Since:
        9i
      • getCursor

        ResultSet getCursor​(int columnIndex)
                     throws 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:
        SQLException - if a database access error occurs
      • getCursor

        ResultSet getCursor​(String columnName)
                     throws 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:
        SQLException - if a database access error occurs
      • getCustomDatum

        CustomDatum getCustomDatum​(int columnIndex,
                                   CustomDatumFactory factory)
                            throws 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:
        SQLException - if a database access error occurs.
      • getORAData

        ORAData getORAData​(int columnIndex,
                           ORADataFactory factory)
                    throws 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:
        SQLException - if a database access error occurs.
      • getObject

        Object getObject​(int columnIndex,
                         OracleDataFactory oracleDataFactory)
                  throws SQLException
        Oracle extension Get the column value as an instance of a subclass of OracleData. Which subclass is determined by the factory parameter.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        factory - OracleDataFactory used to materialize the column value
        Returns:
        the column value as a OracleData; if the value is SQL NULL, the result is null
        Throws:
        SQLException - if a database access error occurs.
      • getObject

        Object getObject​(String columnName,
                         OracleDataFactory oracleDataFactory)
                  throws SQLException
        Oracle extension Get the column value as an instance of a subclass of OracleData. Which subclass is determined by the factory parameter.
        Parameters:
        columnName - name of the column "column1" "column2" ..
        factory - OracleDataFactory used to materialize the column value
        Returns:
        the column value as a OracleData; if the value is SQL NULL, the result is null
        Throws:
        SQLException - if a database access error occurs.
      • getCustomDatum

        CustomDatum getCustomDatum​(String columnName,
                                   CustomDatumFactory factory)
                            throws 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:
        SQLException - if a database access error occurs.
      • getORAData

        ORAData getORAData​(String columnName,
                           ORADataFactory factory)
                    throws 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:
        SQLException - if a database access error occurs.
      • getDATE

        DATE getDATE​(int columnIndex)
              throws 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:
        SQLException - if a database access error occurs.
      • getDATE

        DATE getDATE​(String columnName)
              throws 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:
        SQLException - if a database access error occurs.
      • getNUMBER

        NUMBER getNUMBER​(int columnIndex)
                  throws 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:
        SQLException - if a database access error occurs.
      • getNUMBER

        NUMBER getNUMBER​(String columnName)
                  throws 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:
        SQLException - if a database access error occurs.
      • getOracleObject

        Datum getOracleObject​(int columnIndex)
                       throws 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:
        SQLException - if a database access error occurs.
      • getOracleObject

        Datum getOracleObject​(String columnName)
                       throws 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:
        SQLException - if a database access error occurs.
      • getRAW

        RAW getRAW​(int columnIndex)
            throws 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:
        SQLException - if a database access error occurs.
      • getRAW

        RAW getRAW​(String columnName)
            throws 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:
        SQLException - if a database access error occurs.
      • getREF

        REF getREF​(int columnIndex)
            throws 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:
        SQLException - if a database access error occurs.
      • getREF

        REF getREF​(String columnName)
            throws 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:
        SQLException - if a database acc
      • getROWID

        ROWID getROWID​(int columnIndex)
                throws 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:
        SQLException - if a database access error occurs.
      • getROWID

        ROWID getROWID​(String columnName)
                throws 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:
        SQLException - if a database access error occurs.
      • getSTRUCT

        STRUCT getSTRUCT​(int columnIndex)
                  throws 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:
        SQLException - if a database access error occurs.
        See Also:
        getORAData(int,oracle.sql.ORADataFactory)
      • getSTRUCT

        STRUCT getSTRUCT​(String columnName)
                  throws 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:
        SQLException - if a database access error occurs.
        See Also:
        getORAData(int,oracle.sql.ORADataFactory)
      • updateARRAY

        void updateARRAY​(int columnIndex,
                         ARRAY value)
                  throws SQLException
        Oracle extension. Updates a column with an oracle.sql.ARRAY value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateARRAY

        void updateARRAY​(String columnName,
                         ARRAY value)
                  throws SQLException
        Oracle extension. Updates a column with an oracle.sql.ARRAY value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateBfile

        void updateBfile​(int columnIndex,
                         BFILE value)
                  throws SQLException
        Oracle extension. Updates a column with an oracle.sql.BFILE value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateBFILE

        void updateBFILE​(int columnIndex,
                         BFILE value)
                  throws SQLException
        Oracle extension. Updates a column with an oracle.sql.BFILE value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateBfile

        void updateBfile​(String columnName,
                         BFILE value)
                  throws SQLException
        Oracle extension. Updates a column with an oracle.sql.BFILE value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateBFILE

        void updateBFILE​(String columnName,
                         BFILE value)
                  throws SQLException
        Oracle extension. Updates a column with an oracle.sql.BFILE value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateBLOB

        void updateBLOB​(int columnIndex,
                        BLOB value)
                 throws SQLException
        Oracle extension. Updates a column with an oracle.sql.BLOB value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateBLOB

        void updateBLOB​(String columnName,
                        BLOB value)
                 throws SQLException
        Oracle extension. Updates a column with an oracle.sql.BLOB value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateCHAR

        void updateCHAR​(int columnIndex,
                        CHAR value)
                 throws SQLException
        Oracle extension. Updates a column with an oracle.sql.CHAR value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateCHAR

        void updateCHAR​(String columnName,
                        CHAR value)
                 throws SQLException
        Oracle extension. Updates a column with an oracle.sql.CHAR value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateCLOB

        void updateCLOB​(int columnIndex,
                        CLOB value)
                 throws SQLException
        Oracle extension. Updates a column with an oracle.sql.CLOB value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateCLOB

        void updateCLOB​(String columnName,
                        CLOB value)
                 throws SQLException
        Oracle extension. Updates a column with an oracle.sql.CLOB value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateCustomDatum

        void updateCustomDatum​(int columnIndex,
                               CustomDatum value)
                        throws SQLException
        Deprecated.
        Oracle extension. Updates a column with an CustomDatum value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateORAData

        void updateORAData​(int columnIndex,
                           ORAData value)
                    throws SQLException
        Oracle extension. Updates a column with an ORAData value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateCustomDatum

        void updateCustomDatum​(String columnName,
                               CustomDatum value)
                        throws SQLException
        Deprecated.
        Oracle extension. Updates a column with an CustomDatum value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateORAData

        void updateORAData​(String columnName,
                           ORAData value)
                    throws SQLException
        Oracle extension. Updates a column with an ORAData value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateDATE

        void updateDATE​(int columnIndex,
                        DATE value)
                 throws SQLException
        Oracle extension. Updates a column with an oracle.sql.DATE value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateDATE

        void updateDATE​(String columnName,
                        DATE value)
                 throws SQLException
        Oracle extension. Updates a column with an oracle.sql.DATE value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateINTERVALYM

        void updateINTERVALYM​(int columnIndex,
                              INTERVALYM value)
                       throws SQLException
        Oracle extension. Updates a column with an oracle.sql.INTERVALYM value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateINTERVALYM

        void updateINTERVALYM​(String columnName,
                              INTERVALYM value)
                       throws SQLException
        Oracle extension. Updates a column with an oracle.sql.INTERVALYM value.
        Parameters:
        columnName - the name of the column to update
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateINTERVALDS

        void updateINTERVALDS​(int columnIndex,
                              INTERVALDS value)
                       throws SQLException
        Oracle extension. Updates a column with an oracle.sql.INTERVALDS value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateINTERVALDS

        void updateINTERVALDS​(String columnName,
                              INTERVALDS value)
                       throws SQLException
        Oracle extension. Updates a column with an oracle.sql.INTERVALDS value.
        Parameters:
        columnName - the name of the columnt to update
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateTIMESTAMP

        void updateTIMESTAMP​(int columnIndex,
                             TIMESTAMP value)
                      throws SQLException
        Oracle extension. Updates a column with an oracle.sql.TIMESTAMP value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateTIMESTAMP

        void updateTIMESTAMP​(String columnName,
                             TIMESTAMP value)
                      throws SQLException
        Oracle extension. Updates a column with an oracle.sql.TIMESTAMP value.
        Parameters:
        columnName - The name of the column to update
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateTIMESTAMPTZ

        void updateTIMESTAMPTZ​(int columnIndex,
                               TIMESTAMPTZ value)
                        throws SQLException
        Oracle extension. Updates a column with an oracle.sql.TIMESTAMPTZ value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateTIMESTAMPTZ

        void updateTIMESTAMPTZ​(String columnName,
                               TIMESTAMPTZ value)
                        throws SQLException
        Oracle extension. Updates a column with an oracle.sql.TIMESTAMPTZ value.
        Parameters:
        columnName - the name of the column to update
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateTIMESTAMPLTZ

        void updateTIMESTAMPLTZ​(int columnIndex,
                                TIMESTAMPLTZ value)
                         throws SQLException
        Oracle extension. Updates a column with an oracle.sql.TIMESTAMPLTZ value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateTIMESTAMPLTZ

        void updateTIMESTAMPLTZ​(String columnName,
                                TIMESTAMPLTZ value)
                         throws SQLException
        Oracle extension. Updates a column with an oracle.sql.TIMESTAMPLTZ value.
        Parameters:
        columnName - the name of the column to update
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateNUMBER

        void updateNUMBER​(int columnIndex,
                          NUMBER value)
                   throws SQLException
        Oracle extension. Updates a column with an oracle.sql.NUMBER value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateNUMBER

        void updateNUMBER​(String columnName,
                          NUMBER value)
                   throws SQLException
        Oracle extension. Updates a column with an oracle.sql.NUMBER value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateOracleObject

        void updateOracleObject​(int columnIndex,
                                Datum value)
                         throws SQLException
        Oracle extension. Updates a column with an oracle.sql.xxx value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateOracleObject

        void updateOracleObject​(String columnName,
                                Datum value)
                         throws SQLException
        Oracle extension. Updates a column with an oracle.sql.xxx value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateRAW

        void updateRAW​(int columnIndex,
                       RAW value)
                throws SQLException
        Oracle extension. Updates a column with an oracle.sql.RAW value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateRAW

        void updateRAW​(String columnName,
                       RAW value)
                throws SQLException
        Oracle extension. Updates a column with an oracle.sql.RAW value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateREF

        void updateREF​(int columnIndex,
                       REF value)
                throws SQLException
        Oracle extension. Updates a column with an oracle.sql.REF value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateREF

        void updateREF​(String columnName,
                       REF value)
                throws SQLException
        Oracle extension. Updates a column with an oracle.sql.REF value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateROWID

        void updateROWID​(int columnIndex,
                         ROWID value)
                  throws SQLException
        Oracle extension. Updates a column with an oracle.sql.ROWID value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateROWID

        void updateROWID​(String columnName,
                         ROWID value)
                  throws SQLException
        Oracle extension. Updates a column with an oracle.sql.ROWID value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateSTRUCT

        void updateSTRUCT​(int columnIndex,
                          STRUCT value)
                   throws SQLException
        Oracle extension. Updates a column with an oracle.sql.STRUCT value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • updateSTRUCT

        void updateSTRUCT​(String columnName,
                          STRUCT value)
                   throws SQLException
        Oracle extension. Updates a column with an oracle.sql.STRUCT value.
        Parameters:
        columnName - is the SQL name of the column
        value - the new column value
        Throws:
        SQLException - if a database access error occurs
      • isFromResultSetCache

        boolean isFromResultSetCache()
                              throws SQLException
        Oracle extension. Returns true if resultset is from cache otherwise false.
        Returns:
        Throws:
        SQLException
      • getCompileKey

        byte[] getCompileKey()
                      throws SQLException
        Oracle extension. Get compile key calculated for caching the result.
        Returns:
        Throws:
        SQLException
      • getRuntimeKey

        byte[] getRuntimeKey()
                      throws SQLException
        Oracle extension. Get runtime key calculated for caching the result.
        Returns:
        Throws:
        SQLException
      • publisherOracle

        default <T> Flow.Publisher<T> publisherOracle​(java.util.function.Function<? super OracleRow,​T> rowMappingFunction)
                                               throws SQLException

        Returns a Publisher that publishes the rows of this ResultSet beginning with the first row. A rowMappingFunction defines the type T which rows are published as. Each OracleRow is valid only for the duration of the call to the rowMappingFunction. OracleRow.clone() will create a new instance of OracleRow which persists after the rowMappingFunction returns. An unchecked exception thrown by the row mapping function is emitted as an onError signal to subscribers.

        The returned Publisher supports multiple Subscribers. Subscribers which subscribe after some rows are published will not see the already published rows. It may be the case that rows are published only when all subscribers have requested additional rows.

        This method closes the ResultSet.

        Asynchronous tasks initiated by this method will execute under the current AccessControlContext of the calling thread.

        Parameters:
        rowMappingFunction - Function applied to each row which produces the published type T.
        Returns:
        a Publisher of the rows of this ResultSet
        Throws:
        SQLException - If a database error occurs, if this method is called on a closed ResultSet, or if this ResultSet's cursor has been moved from its initial position before the first row.
        Since:
        20
    </section>