Sponsored

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;




Oracle Forms Recipes eBookDownload

Example is given to loop through records in data block in oracle forms.

Post a Comment

V. Kapoor

{picture#https://3.bp.blogspot.com/-q3wCssWUHo8/ViDFfCpPEuI/AAAAAAAAD0M/MHPvgnl3T3U/s1600/authpic.JPG} Vinish Kapoor is a Software Consultant, currently working in a reputed IT company in Noida, India and doing blogging on Oracle Forms, SQL and PLSQL topics. He is an author of an eBook Oracle Forms Recipes, which is available on Google play. {facebook#https://www.facebook.com/foxinfotech2014} {twitter#https://twitter.com/foxinfotech} {google#https://plus.google.com/u/0/+VKapoor/posts}
Fox Infotech. Powered by Blogger.