Hello:

I've an ArrayList which contains bulk records and I want to insert all of those in a single statement (or Bulk insert). I know it can be done if I use Oracle.DataAccess (it supports bulk insert). But I'm not gonna use it rather use a single insert statement like below:

StringBuilder strSQL = new StringBuilder();
                    conn.Open();
                    com.Connection = conn;

                    strSQL.Append("INSERT ALL");
                    strSQL.Append(" INTO TEST "
                                            + " VALUES('"
                                            + "ID"
                                            + "','" + "Person"
                                            + "','" + "Location"
                                            + "') "
                                            );
                    strSQL.Append(" INTO TEST "
                                            + " VALUES('"
                                            + newItems[0].ToString()
                                            + "','" + newItems[1].ToString()
                                            + "','" + newItems[2].ToString()
                                            + "') "
                                            );


                    com.CommandText = strSQL.ToString();
                    com.ExecuteNonQuery();

The above is generating error. Can anyone help me to figure it out.

Thanks/Razin