Requirement:
Lazy loading in Oracle Apex
Step1:
Create a page
Step 2:
Create a report region
Step 3:
Create a hidden page item
Ex : P1_HIDDEN
Step 4:
Create on- load before header PL/SQL process and assign the value ‘N’
for that hidden item.
Step 5:
In report query add the condition as :P1_HIDDEN=’J’
Step 6:
Create a dynamic action on page load, with the following true actions
1. Set the value ‘J’ for hidden item.
2. Submit the value of hidden item.
3. Refresh the report region.
By
Preethi J
Recommended Posts
