Region level errors are not caught using the method above. An example of a region error is when you have a query that has divisor is equal to zero error. To simulate this error create a standard report region with the following query:
WHERE 1 / 0 = 0 -- Causes an ORA-01476: divisor is equal to zero
This query will return a "ORA-01476: divisor is equal to zero" error message in APEX.
Starting with APEX 4.0 region level errors are logged in the APEX Activity Log. The following query identifies both page and region level errors:
error_on_component_name -- Region/Process that caused the issue
WHERE error_message IS NOT NULL
I strongly recommend that you frequently scan the activity logs for errors. Part 2 of will describe a way to be automatically notified of region level errors.
They're a few caveats that you should be aware of:
- As mentioned, the activity log identifies both region and page level errors. APEX_WORKSPACE_ACTIVITY_LOG.ERROR_ON_COMPONENT_NAME identifies the region or process that the error occured in.
- When multiple region level errors occur only the first error is logged in the activity log.
- From my limited testing, errors in Interactive Reports are not logged. Their may be other types of regions that don't log errors as well.
Given the caveats listed above querying the activity logs help identify some, but not all, errors that happen in your application.
APEX Region Errors - Part 2