Press "Enter" to skip to content

Moving From Top To Bottom in Detailed Block in Oracle Forms

Suppose you want to scan a tabular grid block (loop through all records in detail block) from top to bottom in Oracle forms. You can do this task by using :system.last_record system variable to determine whether it is last record in a block and then exit.
Example:
Begin
   go_block(‘yourblock’);
   — then move to first record
   first_record;
   Loop
      — do some processing
      null;
      if :system.last_record = ‘TRUE’ then
         exit;
      End if;
      next_record;
   End Loop;
   — after exiting move to top
   first_record;
End;