![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e303. Inserting a VARRAY Value into an Oracle Table Using a Prepared StatementThis example inserts a row with a VARRAY of numbers as defined in e301 Creating a VARRAY Type in an Oracle Database. This example uses a prepared statement.try { // Create an oracle.sql.ARRAY object to hold the values oracle.sql.ArrayDescriptor arrayDesc = oracle.sql.ArrayDescriptor.createDescriptor("number_varray", connection); int arrayValues[] = {123, 234}; oracle.sql.ARRAY array = new oracle.sql.ARRAY(arrayDesc, connection, arrayValues); // Create a prepared statement for insertion into varray_table PreparedStatement ps = connection.prepareStatement("INSERT INTO varray_table VALUES(?)"); // Set the values to insert ((oracle.jdbc.driver.OraclePreparedStatement)ps).setARRAY(1, array); // Insert the new row ps.execute(); } catch (SQLException e) { }
e302. Inserting a VARRAY Value into an Oracle Table e304. Getting a VARRAY Value from an Oracle Table © 2002 Addison-Wesley. |