title: populating data using cursor in oracle forms
body: <p>I have created a block with 4 text items which i have to populate using a cursor.</p>
  
  <p>I have written a code in the same blocks post-query trigger which is as follows:</p>
  
  <pre><code>DECLARE
  
      CURSOR D_COMM_DET IS
          SELECT COMM_SRNO, COMM_SUB_SRNO, COMM_REASON 
          FROM CUST_COMM
          WHERE LEAD_ID = :INQUIRY.INQ_ID; -- master block "INQUIRY"
  BEGIN
  
      GO_BLOCK('DISPLAY_DET');
      CLEAR_BLOCK('NO_VALIDATE');
      FIRST_RECORD;
      FOR CUR IN D_COMM_DET 
      LOOP
      :DISPLAY_COMM_DET.A_COMM_SRNO := CUR.COMM_SRNO;
      :DISPLAY_COMM_DET.A_COMM_SUB_SRNO := CUR.COMM_SUB_SRNO;
      :DISPLAY_COMM_DET.A_COMM_REASON := CUR.COMM_REASON;
      NEXT_RECORD;
      END LOOP;
      FIRST_RECORD;
  
  END;
  </code></pre>
  
  <p>But this is not populating the data in the text items neither it is showing any errors.
  Can anyone help regarding the same.</p>
  
  <p>Thankyou.</p>