Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

oracle apex prevent initial load

-- 1. Put a HIDDEN field P1_IS_LOADED in the region

-- 2. Requesting datas in region becomes:
SELECT /* your columns */
  FROM /* your tables */
WHERE 1 = 1 
  AND nvl(:P1_IS_LOADED, 'N') = 'Y'
   
-- 3. At page level:
>> Post-Rendering > After Regions > Computation > add one computation with: 
	Computation: Static Value: Y
Source by askmax.blog #
 
PREVIOUS NEXT
Tagged: #oracle #apex #prevent #initial #load
ADD COMMENT
Topic
Name
3+4 =