title: ORA-00900: invalid SQL statement when using loop to insert rows
body: <p>I'm trying to insert multiple rows into an Oracle 11g table by running the following in Aqua Data Studio (version 15.0.11), using this:</p>
  
  <pre><code>BEGIN
      FOR i IN 1..700 LOOP
          INSERT INTO lims.stock_template (
              stock_template_id,
              name,
              group_id,
              version,
              version_status,
              workflow_id,
              amount,
              stock_type_id,
              aliquot_template_id,
              auto_authorise,
              reorder_amount
              )
          VALUES (
              lims.sq_stock_template.nextval,
              lims.sq_stock_template.currval,
              21,
              1,
              'A',
              51881,
              0,
              103,
              2362,
              'F',
              0
              );
      END LOOP;
  END;
  /
  </code></pre>
  
  <p>but I get the following error:</p>
  
  <pre><code>&gt;[Error] Script lines: 30-30 ------------------------
   ORA-00900: invalid SQL statement
   Script line 30, statement line 1, column 0 
  </code></pre>
  
  <p>If I run just the INSERT statement by itself, it works just fine, but I want to be able to insert multiple rows in one operation.</p>
  
  <p>I'm sure that I've run something similar in the past, but I can't see what the problem is.</p>
  
  <p>Any help much appreciated.</p>
  
  <p>Thanks</p>