I am displaying a file using a wpg_docload.download_file(v_bfile); call from a PL/SQL procedure that is called on a button
which works fine once I put a call to APEX_APPLICATION.g_unrecoverable_error inside the procedure , as below.
APEX_APPLICATION.g_unrecoverable_error := FALSE;
The button is supposed to automatically refresh (reload, resubmit) the page once that operation is finished. However the page does not refresh unless I remove the APEX_APPLICATION.g_unrecoverable_error line, which in turn means the file is not displayed.
I have tried putting in a APEX_APPLICATION.g_unrecoverable_error= TRUE at the end of the procedure and in Apex where the button is called but the system is not having any of it.
How can I get the file to display (dialog button to appear) and then the redirect to work please..