I am trying to figure out a stored proc to perform multiple inserts in the form of arrays:
incoming data:
field1[]
field2[]
field3[]
field4[]
field5[]

table definition: (table name: tblTarget)
column1
column2
column3
column4
column5

Correspondingly, insert fields into columns via JDBC call of a stored proc. Therefore, I don't have to loop through doing every insert for each row of fields, and simply with one stored proc call to complete multiple inserts. I am wondering what the stored proc would look like and any necessary error/exception handling I need to do.

Thanks a lot for your time.

W-