LAZY LOADING

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

  • January 2, 2017 | 42 views