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;
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