Friday, October 19, 2018

Oracle Forms Loop through items in data block

Below code will help you to navigate through all the records of data block in Oracle Forms.

BEGIN
GO_BLOCK('DATABLOCK_NAME');
FIRST_RECORD;
LOOP
-- Here you can add your logic like displaying message,setting item property etc----
......
......
......
EXIT WHEN :SYSTEM.LAST_RECORD='TRUE';
NEXT_RECORD;
END LOOP;
FIRST_RECORD;
END;

No comments:

Post a Comment

Launch Concurrent Program from Menu

The below detailed steps help you to call concurrent program form Menu. Step 1: Create a Form Function Navigation: Application Develope...