I have a scenario where I both have to process a form and download a pfd that was created in that submit process. Very much like this:
https://joelkallman.blogspot.com/2017/12/errors-when-downloading-file-on-page.html
However, setting "Reload on submit" to "Always" doesn't seem to reload the page at all after detection of apex_application.stop_apex_engine.
So I created a simpler example on apex.oracle.com:
https://apex.oracle.com/pls/apex/f?p=56646:2
- Form on table EMP.
- "Reload on submit" = "Always"
- Create a Submit process after the Automatic Row Processing:
raise_application_error(-20001,'Intentional error');
The "Reload on submit" seems to be stuck halfway or something (just click on Apply Changes).
Running the page in Debug mode shows that Apex actually continues with "R E Q U E S T show" after the error:
...Process "Raise error" - Type: NATIVE_PLSQL
begin raise_application_error(-20001,'Intentional error');
end;
Exception in "plsql process":
Error Stack: ORA-20001: Intentional error
(...)
...Inline Errors detected, performing rollback
Show current page with inline errors
R E Q U E S T show
(... Apex continues with building the page ...)
Processes - point: AFTER_FOOTER
Final commit
Is this expected behaviour (i.e. am I missing something here) or is this a bug?