الأحد، 15 أغسطس 2021

How to change Region read only on runtime in Oracle APEX

 1: Make P6_REGION_ID

that will contain all Region available for your page 

use this code as source 

select 
PLUG_NAME,
ID
 from APEX_200200.wwv_flow_page_plugs
                    where FLOW_ID =:P6_FLOW_ID
                    and   PAGE_ID =:P6_STEP_ID

  and make process to update Region read only

 BEGIN

UPDATE APEX_200200.wwv_flow_page_plugs -- Region

SET PLUG_READ_ONLY_WHEN_TYPE = 'EXISTS' ,

    PLUG_READ_ONLY_WHEN = 'SELECT 1 from dual where 1 =2 '

WHERE FLOW_ID = :P6_FLOW_ID -- APP ID

 and PAGE_ID = :P6_STEP_ID  -- PAGE ID

 and ID = :P6_REGION_ID -- REGION ID

end;

thanks

هناك تعليقان (2):

How to Solve Ords Issue : The request could not be mapped to any database.

 The request could not be mapped to any database.  Check the request URL is correct, and that URL to database mappings have been correctly c...