title: Performing multiple inserts at once in oracle with ExecuteNonQuery
body: <p>I'm trying to execute multiple inserts at once like this</p>
  
  <pre><code>var mydict =  new Dictionary&lt;int, int&gt; { { 1, 2 }, { 3, 4 } };
  
  var query = string.Join("; ", mydict.Select(x =&gt; $"insert into myTable (colA, colB) values ({x.Key},{x.Value})"));
  
  using(var connection = new new OracleConnection(dbConnectionString))
  {
      var command = connection.CreateCommand();
      command.CommandText = query;
      command.ExecuteNonQuery();
  }     
  </code></pre>
  
  <p>but i got <code>Oracle.ManagedDataAccess.Client.OracleException: 'ORA-00911: invalid character'</code> even I can manually execute the generated query from sqldeveloper with no issues.</p>
  
  <p>I alreay did this in the past with sqlserver and sqlite, and i had no issues.</p>
  
  <p>why this happens? is there a cleaner way?</p>
  
  <hr>
  
  <p>here is the generated sql:</p>
  
  <pre><code>insert into myTable (colA, colB) values (72520,2452); insert into myTable (colA, colB) values (73293,2453)
  </code></pre>