CODEWITHSUNDEEP
validationoracle-apexoracle-apex-5.1
pccdavef
pccdavef

Reputation: 79

Oracle APEX 5.1 validation not executing

I have a page that contains with a standard Save and Close button. I've written a page validation "PL/SQL Function (Returning Error Text)", with the following settings:

"Always Execute" is "No"
Server Side Condition "When Button Pressed" is "Save".
I've included some debugging statements in the function body that write entries to a log table indicating progress through the function for my personal use.

The Save button has the following settings:
Action is "Submit Page"
Execute Validations is "Yes"

However, when the button is clicked (the page is submitted), the validation is not being executed - there are no database log table entries as expected, and when I look at the debug log for the page there are no entries that indicate the validation was run or that a return value had been received.

According to the Oracle documentation, these settings should fire the validation; any ideas why it's not running are appreciated.

Upvotes: 1

Views: 1741

Answers (1)

pccdavef
pccdavef

Reputation: 79

The problem ended up being that I had the database save process executing at the "After Page Submit" execution point, which happens before "Validating". Once I moved the database action to the "Processing" execution point (which happens after "Validating"), the validation executed as expected.

Thanks for everyone's response.

Upvotes: 0

Related Questions