In this tutorial, I am giving an example to display a value from another table on page load in Oracle Apex using the Process.
Suppose you have a form based on Employee information and there is a field Department Number which refers to DEPT table. You require to display the department name from DEPT table whenever a form is opened in EDIT mode. To perform this task, follow these steps:
Oracle Apex Process Example - Display a Value from Another Table on Page Load
Step-1: Create a page item next to Department number item and set the type of the item as Display Only.
Step-2: Create a process in before header section and set the following properties as shown in the below image:
Enter the following PL/SQL code in the above PL/SQL code section:
declare
v_dname dept.dname%type;
begin
select dname into v_dname
from dept where deptno = :p3_deptno;
apex_util.set_session_state('P3_DNAME', v_dname);
exception
when others then
null;
end;Now when you will open the form, it will display the department name value as shown in the below image:
