Inserting a VARRAY Value into an Oracle Table
This example inserts a row with a VARRAY as defined in
Creating a VARRAY Type in an Oracle Database.
try {
// Create a statement
Statement stmt = connection.createStatement();
// Insert a row with an array of two values
stmt.execute ("INSERT INTO varray_table VALUES(number_varray(123, 234))");
} catch (SQLException e) {
}
Post a comment