Change Region Bulid Option on runtime in Oracle APEX

Table of contents

No heading

No headings in the article.

First, Make P6_REGION_ID

that will contain all Region available for your page

use this code as a 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 select list item P6_BUILD_OPTION

that will contain all build Options available for your APP

use this code as a source

select PATCH_NAME,ID from APEX_200200.wwv_flow_patches where FLOW_ID =:P6_FLOW_ID

and make a process to update Region Build Option

BEGIN

UPDATE APEX_200200.wwv_flow_page_plugs

SET REQUIRED_PATCH = :P6_BUILD_OPTION

WHERE FLOW_ID = :P6_FLOW_ID

and PAGE_ID = :P6_STEP_ID

and ID = :P6_REGION_ID ;

end;