How to Get Previous Record Value in Oracle Forms?

How to Get Previous Record Value in Oracle Forms?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

To get previous record value in Oracle Forms, use Previous_Record built-in. Previous_Record command navigates to the next lower sequence number than the current record. To get the current record number you can use System.Cursor_Record system variable. Below is the example:

Get Previous Record Values in Oracle Forms Example

Suppose you have a database block EMP and there are fields empno, ename, job and you want to get previous record values for some purpose, then create a push button and on that button click trigger, use Previous_Record built-in as shown in the below example:

DECLARE
   l_prev_empno   emp.empno%TYPE;
   l_prev_ename   emp.ename%TYPE;
   l_prev_job     emp.job%TYPE;
BEGIN
   IF TO_NUMBER (:SYSTEM.cursor_record) > 1
   THEN
      PREVIOUS_RECORD; /* move to the previous record and get previous record values */
      l_prev_empno := :emp.empno;
      l_prev_ename := :emp.ename;
      l_prev_job := :emp.job;
      NEXT_RECORD;    /* come back to the current record */
   END IF;
END;

See also: