Environment:
- Database - Oracle 19c (19.0.0)
- Front End - Oracle APEX (21.2.3)
I have a page item (that is part of a Form region) that is of Type - Number field tied to a database column of NUMBER type. The business rules are
- Entry field: Pre R5
- Numerical entry only
- Field should allow 2 decimal points
- Range: 0.00 to 99.00
In my page item definition, I have:
I also have a dynamic action that is an “Execute Server-side” action. In it is a formula for another page item that is DERIVED from this field and another.
So if this page item breaks the rules of outside the number range it works fine with the D/A disabled. As soon as I enable the dynamic action, since one of the columns in the formula will cause the result to exceed the range, I'll get an error.
Now I am doing unit testing so the current value is
So, in the theory you can have 5 chars of “99.99” format, but I could type in a value of “12345”, so I wanted to get a warning, by putting in 199.7. I received this error message:
The D/A formula is: “derived_page_item = page item 1 (Pre R5) - page item 2 (Pre R20)”
Since 199.75 - 37.00 = 162.75 that exceeds the upper bound range of 99.99 for the derived item.
How can I trap this cleanly?