Press "Enter" to skip to content

How to Check First and Last Record in Oracle Forms?

In Oracle Forms, to check for the first record use System.Cursor_Record system variable and to check for the last record use System.Last_Record system variable. Below are the examples:

Check If First Record in Oracle Forms

System.Cursor_Record return the current number of record in Oracle Forms in char. Suppose you have a tabular database block, in which you have multiple records then use System.Cursor_Record to determine the current record number. Below is an example of determining the first record:

BEGIN
   IF :SYSTEM.Cursor_Record = '1'
   THEN
      MESSAGE ('At first record.');
   END IF;
END;

Check If the Last Record in Oracle Forms

Use System.Last_Record to check if the last record. System.Last_Record returns the char value TRUE or FALSE. Below is an example:

BEGIN
   IF :SYSTEM.LAST_RECORD = 'TRUE'
   THEN
      MESSAGE ('At last record.');
   END IF;
END;

See also: