e304. getting a varray value from an oracle table.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 20 行

This example retrieves values contained in an Oracle VARRAY type. The example uses the table and array type created in e301 Creating a VARRAY Type in an Oracle Database. 
    try {
        // Create a statement
        Statement stmt = connection.createStatement();
    
        // Select rows from varray_table
        ResultSet resultSet = stmt.executeQuery("SELECT * FROM varray_table");
    
        // Get the VARRAY values from each row
        while (resultSet.next()) {
            // Get the VARRAY value in the first column
            oracle.sql.ARRAY array = ((oracle.jdbc.driver.OracleResultSet)resultSet).getARRAY(1);
    
            // Get the VARRAY elements; values.length is the number of values in the VARRAY
            java.math.BigDecimal[] values = (java.math.BigDecimal[])array.getArray();
        }
    } catch (SQLException e) {
    }