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

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.

You may also like:

Be First to Comment

    Leave a Reply

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