When an after-submit process on a page raises an unhandled PL/SQL exception, the Apex engine redirects to an error page that shows just the top level exception i.e.
ORA-1403 no data found
, no line numbers, no procedure names, nothing.
This is singularly useless to help us figure out what the problem is.
Even running the page in debug mode doesn't help because it just shows
Encountered unhandled exception
Show ERROR page
Performing rollback
Simple example: If my unconditional after submit process has
raise_application_error(-20000,'Bad thing happened!');
this is what I get when I submit the page
http://i1.tinypic.com/4huk3fk.jpg
[Heck, in this case, I don't even get the ORA-20001 error I raised, I get a blank error message with that Stop symbol!]
In comparison, when we run the same PL/SQL pacakged procedure using SQL*Plus, we get the full error stack with line numbers that help to easily pinpoint the problem.
Is there a way to get the Apex engine to show us the full error stack?
Thanks