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;

Vinish Kapoor

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Be First to Comment

    Leave a Reply

    Your email address will not be published. Required fields are marked *