How to Insert an Array in an Oracle Database With JBoss Seam

A database array is a list of records stored in a table that you must insert into another table. You use a combination of the "select" and "insert" statements to insert the array of data from the JBoss Seam development environment connection to an Oracle server.

Instructions

1. Open the JBoss Seam software on the computer you use to set up and configure your Oracle database procedures.

2. Click the "New Procedure" button to open an editor for a new Oracle stored procedure that you use to insert an array.

3. Add the PL/SQL code to insert the array of items. For instance, if you want to insert an array of customers from "table1" to "table2," use the following code:

   insert into table2 select * from table1

   The code above transfers all records from table1 into table2. Change these table names to match your own table names.

4. Click the "Save" button to save the procedure. Click "Run" to execute the procedure to test it on the Oracle server.

References

• JBoss: RichFaces Developer Guide
• Oracle: Ask Tom: Thanks for the Question Regarding "Bulk Insert of Records, Using Something Like a User Defined Record?"