I discovered this, probably someone else out there might find it interesting.....but, it's a bad idea to have several round-trips to the database when you want to insert many records (rows). It would be nice to build an array of values to insert with one statement. This can be done easily using ADO.Net:
comm.CommandText = "insert into blah_lnk (asdf,asdfasdf) values (:1,:2)"
comm.ArrayBindCount = <array_length> Dim id_arr(
<array_length>-1) As System.Int32
For c As System.Int32 = 0 To id_arr.Length - 1
id_arr(c) = CType(Session("asdfasdf"), System.Int32)
Next
Dim orap As New Oracle.DataAccess.Client.OracleParameter("1", OracleDbType.Varchar2)
orap.Value = id_arr
orap.Direction = ParameterDirection.Input
comm.Parameters.Add(orap)
Dim orap2 As New Oracle.DataAccess.Client.OracleParameter("2", OracleDbType.Varchar2)
orap2.Value = arr.ToArray()
orap2.Direction = ParameterDirection.Input
comm.Parameters.Add(orap2)
comm.ExecuteNonQuery()
...anyway, the idea is that you can execute the statement on the array, and allow yourself only one round-trip to the database. I'm not a DB programmer, so this is probably well known, but I didn't know it....