Hello everyone,
I'm looking for guidance on the best practice for creating or generating a standard APEX form page (a page based on a single table) programmatically using a SQL or PL/SQL script, rather than through the APEX Page Wizard.
My goal is to automate the deployment of many similar pages across different environments.
I understand there are generally two approaches, and I'd appreciate advice on which is recommended for maintaining declarative integrity:
-
Using the **APEX_APPLICATION_...** APIs: Generating a script that contains calls to the internal APEX APIs (like APEX_APPLICATION_PAGE_ITEMS.CREATE_ITEM) to define the page metadata.
-
Exporting and Modifying: Creating one reference page via the wizard, exporting the .sql script, and then modifying that script (perhaps programmatically) to create new pages
I am seeking for the help any suggestion will be appreciated …..