I am running Oracle APEX version 22.2 on our 19c database. The scenario is as follows:
I have a page defined with multiple regions (forms and IG's) with each region displaying various pieces of information for the selected database server. I navigate to this page by clicking on a database server name on a separate page.
The issue I'm having is I'm getting an ORA-01403: no data found error page displayed when the page tries to render. Depending on the database server this can be a valid scenario so what I'd like to do is capture this error and display the error (like “No Data Found”) within the region (form or IG) rather than getting this annoying error page.
Below is a screen print of the page. The issue is in the Initialize form Server Information process and the sql script which is returning the ORA-01403 is under the Source section.
Any assistance would be appreciated.
Thanks,
Jeff