Oracle Apex PL/SQL Function - If all are empty then

Question

I have a big amount of page items in a Oracle Apex 19 page.

If all of those page items are empty, there should be an error. However, if just one of them is not empty, there should be no error.

I could just create a large if statement, but is there a elegant way to solve this using a PL/SQL function body validation?

Didn't check, but there could be a method to iterate through all page items. Wouldn't be faster but easier to implement/maintain — Thomas Strub

sim0n sim0n · Accepted Answer · 2020-02-10T17:34:42

you could check your items using coalesce:

  return coalesce(:P100_DEMO_ITEM1,:P100_DEMO_ITEM2,:P100_DEMO_ITEM3) IS NOT NULL;