Hi,
I’m working on an Oracle APEX application where I use custom PL/SQL functions to handle business logic. These functions can encounter errors, and I want to display these errors on the page (e.g., as inline messages or notifications) instead of raising exceptions with RAISE_APPLICATION_ERROR.
I’m not sure how to pass these errors from my PL/SQL function into APEX without stopping the process (as RAISE_APPLICATION_ERROR does).
How can return custom error messages from PL/SQL functions and display them on the page?