الثلاثاء، 13 يوليو 2021

How to change Build Option for Page on runtime in Oracle APEX

    first make select list item  P7_BUILD_OPTION

that will contain all Build Option available for your APP


use this code as source 

  select patch_name||' ('||wwv_flow_lang.system_message(patch_status)||')' d, id r 
  from APEX_200200.wwv_flow_patches where FLOW_ID = :APP_ID


and make process to update Page Build Option

BEGIN
UPDATE APEX_200200.wwv_flow_steps -
SET REQUIRED_PATCH = :P7_BUILD_OPTION  
 WHERE FLOW_ID = :P7_FLOW_ID 
 and ID = :P7_STEP_ID 
end;
--
thanks

ليست هناك تعليقات:

إرسال تعليق

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...