title: Oracle Forms 6I Navigating to Cursor nth Record
body: <p>i have an application i have several blocks they are not database blocks. However i am populating it with records from a Cursor. I have a procedure that loops through the cursor records and displays it on the form.</p>
  
  <p>I want to be able to display the nth record in this cursor in a form how can i achieve this. This would be coded behing the next record button on the form.</p>
  
  <pre><code>Procedure Get_All_Records IS 
  Cursor MyRecords IS 
  
  Select 1,2,3,4,5
  from mytable
  
  Begin
  
  FOR eachRecord In MyRecords LOOP
    field1 := eachRecord.1;
    field2 := eachRecord.2;
    field3 := eachRecord.3;
    field4 := eachRecord.4;
    field5 := eachRecord.5;
  
  END LOOP;
  
  
  End;
  </code></pre>