title: oracle forms loop through a block before or after insert
body: <p>I am trying to insert values of A block into a table in oracle forms after insert like this</p>
  
  <pre><code>GO_BLOCK ('LCL_SP_DTL');
     LAST_RECORD;
     LV_N_LAST_REC := :SYSTEM.TRIGGER_RECORD;
     FIRST_RECORD;
     LV_N_FST_REC := :SYSTEM.TRIGGER_RECORD;
  
     FOR I IN LV_N_FST_REC .. LV_N_LAST_REC
     LOOP
        INSERT INTO LEDGER(LDATE, LTYPE, DESCRIPTION, DEBIT, CREDIT, SID,VID)
             VALUES (:LCLSP_MST.REC_DATE, 'Local Sale', DES, 0, AMOUNT, LS_ID,'LS-' || :LCLSP_MST.REC_ID);
        NEXT_RECORD;
     END LOOP;
  </code></pre>
  
  <p>But its gving me error not working properly .Plz give any suggestion to insert values in <code>LEDGER</code> on runtime </p>