I'm in the process of porting legacy mod_plsql web applications over to APEX 19.2. I'm new to APEX and trying to figure out the best way to handle internal errors encountered within my external package calls that are called from APEX.
My goals:
- ensure that the error is logged to APEX_DEBUG_MESSAGES (if this is the correct apex table to do this), and
- return a user friendly page error notification that includes a reference to the "View Identifier" in the debug window so the end user can provide it to assist in the troubleshooting.
I am using APEX_DEBUG.ERROR to add a custom error to the error stack for the 1st goal, but not sure how to retrieve APEX's "View Identifier" number to display to user in the 'user friendly' page error message.
Am I over thinking this? Any help pointing me in the right direction would be appreciated. I'm trying to come up with an error handling solution that we can incorporate within all our apps as we port them over.
Thanks in advance,
Mike