title: Getting error PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
body: <p>I am getting </p>
  
  <blockquote>
    <p>Error(68,3): PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL. </p>
  </blockquote>
  
  <p>Please help me out with this.</p>
  
  <p>My code is  : - </p>
  
  <pre><code>create or replace  PACKAGE BODY    FIBRE_TOOLS AS
  
  g_package_name varchar2(30):='FIBRE_TOOLS';
  g_proc_name varchar2(30);   
  </code></pre>
  
  <p>..
  ..
  ..       </p>
  
  <pre><code>   procedure prc_purge(p_nb_month IN number default 210) is
     reqSelec VARCHAR2(4000);
     reqDELDES VARCHAR2(4000);
     reqDELINS VARCHAR2(4000);
  
     TYPE Curseur IS REF CURSOR;
     c_desinscription Curseur;
  
  TYPE selREC IS RECORD (
  
    EMAIL     desinscription.EMAIL%type,
    IDRA      desinscription.IDRA%type,
    D_DATE    desinscription.desinscription_date%type
    );
  
     TYPE selTABLE IS TABLE OF selREC;
     ListeFIB selTABLE;
  
   BEGIN  
      reqSelec :='select EMAIL,IDRA,desinscription_date from desinscription where desinscription_date &lt; trunc(add_months(sysdate,-'||p_nb_month||'))';
  
      reqDELDES := 'DELETE FROM DESINSCRIPTION WHERE EMAIL=:1 AND IRDA=:2';
  
      reqDELINS := 'DELETE FROM INSCRIPTION WHERE EMAIL=:1 AND IDRA=:2 AND INSCRIPTION_DATE &lt; TRUNC(:3)';
      prc_log('Begining of purging procedure');
      open c_desinscription for reqSelec;
      LOOP
      fetch c_desinscription bulk collect into ListeFIB LIMIT 10000;
      EXIT WHEN ListeFIB.count = 0;
      FORALL i in ListeFIB.first.. ListeFIB.last
          EXECUTE IMMEDIATE reqDELDES USING  ListeFIB.EMAIL,ListeFIB.IRDA;
          EXECUTE IMMEDIATE reqDELINS USING ListeFIB.EMAIL,ListeFIB.IDRA,ListeFIB.D_DATE;
          COMMIT;
          EXIT WHEN c_desinscription%NOTFOUND;
      END LOOP;
      close c_desinscription;
      COMMIT;
      prc_log('Ending of purging procedure');
  end prc_purge;
  end FIBRE_TOOLS;
  </code></pre>
  
  <p>I am trying to delete data from two tables based on the two columns getting selected on a criteria I.e. nb_months.</p>
  
  <p>I think problem is with table type and record type. I am confused which way it can be done. As per my knowledge record type shall be used with FORALL. kindly help me on this, as it is very critical.</p>