![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e304. Getting a VARRAY Value from an Oracle TableThis 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) { }
e302. Inserting a VARRAY Value into an Oracle Table e303. Inserting a VARRAY Value into an Oracle Table Using a Prepared Statement © 2002 Addison-Wesley. |