HOW DO I Implement the "Submit" Button in ORACLE APEX

The "Submit" button is a fundamental part of most Oracle APEX applications. It allows users to send form data to the server for processing, such as inserting or updating a database record. When implemented correctly, it ensures data is validated, stored securely, and the user is guided smoothly through the application flow. Oracle APEX makes it easy to configure submit buttons using declarative tools, while also allowing full control with PL/SQL processes. This blog will walk you through how to create and configure a "Submit" button for forms in APEX.

How to Implement a Submit Button in Oracle APEX

1. Add the Submit Button to the Page

   • In Page Designer, go to the Regions section

   • Click + and choose Button

   • Set Button Name (e.g., SUBMIT) and Label (Submit)

   • Set Action to Submit Page

2. Define the Button Action in Processes

   • Under Processing, create a Process Point that runs On Submit - After Computations and Validations

   • Add a new Process (e.g., SAVE_FORM)

   • Choose PL/SQL Code as the type and insert your logic:

     INSERT INTO my_table (name, email)
     VALUES (:P1_NAME, :P1_EMAIL);
     

   • Under Server-side Condition, set:

     • When Button Pressed = SUBMIT

3. Add Validations if Needed

   • Under Validations, add field-level checks to ensure required data is present before processing

   • For example: "P1_EMAIL is not null"

4. Redirect the User After Submit

   • Under Branches, define what happens next

   • Example: Redirect to a confirmation page or reload the current page with a success message

The Submit button simply submits the form and refreshes the page.

Implementation Steps

1. Set the Button Action to Submit Page.

2. No further configuration is required.

This action submits the page and processes any Page Processing Events such as validations or computations.

Best Practices for Submit Buttons in APEX

• Use meaningful button names like SUBMIT, SAVE, or UPDATE

• Always validate inputs before running database operations

• Use server-side conditions on processes to prevent unwanted execution

• Add user feedback using success messages or notifications

• Disable the button after click (use Dynamic Action) to prevent double submissions

• Ensure session state is properly maintained for form items

Oracle APEX Documentation Links

• Creating and Using Buttons

• Working with Page Processes

• Validating and Submitting Data

Conclusion

Implementing a "Submit" button in Oracle APEX is a straightforward process that combines button setup, form processing, validation, and navigation. With the declarative power of APEX and the flexibility of PL/SQL, you can easily handle form submissions securely and reliably. Following best practices ensures that your forms behave as expected, guide the user appropriately, and protect your data integrity. Whether for a simple contact form or a complex transaction, the submit button is a critical part of your application's workflow.