This application using a Tabular Form has been in production for over 10 years. A couple months ago I added validation into the main processing process, so it does RAISE_APPLICATION_ERROR(-20001, err_msg). That displays the error message in the Notification area, not pretty but got the job done for the time-being. I know I can define my own exception handler function, but I didn't do that with this application
The beginning of this week, I looked it over to add another validation exception and confirmed that the application runs as expected. I made the code change and all looked good. Then the next day, a co-worker was doing QA (using our Development database instance) on the change and noticed that when this exception is raised, Apex displays the following error on the page, just above the Tabular Form.
report error:
ORA-01403: no data found
ORA-06510: PL/SQL: unhandled user-defined exception
So I went to compare this functionality against our Production system and, amazingly, it shows the same error when the original exception is raised. But we've never seen this before in the 2 months since the original processing exception was added. It only happens when the exception is raised.
I've searched this forum for an answer but didn't find anything applicable.
Suggestions?
Thanks in advance,
Stew